why won't FIND work in Base forms

answered 2012-07-21 23:30:27 +0200

tohuwawohu
1812 ● 13 ● 40

Base is a frontend for SQL databases. A database isn't a document like a Writer document or a Calc sheet, so you can't expect that Base supports the common operations you're familiar with from Writer, Calc or Impress. If you don't want to handle a huge amount of data, or if your data isn't structured, Base may not the best choice for you if you don't have much experience with SQL databases.

Regarding Base's database object: Forms aren't the best tool to search data in Base. They are mostly a means to input and edit data. If you want to search data, you should create appropriate queries. If your emphasis is generating a printable out, Reports are your friend.

Since Base can handle very huge amounts of data, there a special tools to search and access data. There are three ways to access the data:

• pure SQL: for advanced users - requires SQL knowledge, no GUI help;
• Queries: here you can define queries so you don't have to formulate them every time you want to query your data.
• Reports: use reports to get a "printable" output of your data. The default layouts aren't really good IMHO, but there's a report generator" extension that makes the creation of modern reports easier.

I recommend to check out the available tutorials on using Base, for example this one from sheepdogguides.com (it's for OpenOffice Base, but the concepts are the same).