4GL Patterns #9 – Search

Specific fields are marked as being searchable. User interface and code is automatically generated.

Examples of Search in RAD

• Adding Full Text Indexes to char columns – MySQL, SQLite, SQL Server
• Query By Example (QBE) in MS Access – is a special case where all fields are made searchable
• Autogenerated modal forms with search/filter capabilities. Used when look-up tables get large