Kbase 17690: Using Query By Form (QBF) in Apptivity
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Using Query By Form (QBF) in Apptivity
The Query by Form (QBF) Operation allow users to dynamically
search data sources.
To use QBF at run time, click on the QBF button on the Naviagation
Toolbar. This will blank out the fields linked to the same data
source as the toolbar. Then type search patterns in the desired
fields and click on the "apply filter" button. The QBF button
toggles to the apply filter button when depressed and vice versa.
The following character can be used in search patterns:
% multiple characters
_ (underscore) single character
Although the SQL button is on the Navigation toolbar control, the
filter is actually placed on the data source. Only the controls
on the active form go into QBF more, but once the filter is
placed, it applies to all controls bound to the data source.
To illustrate:
1. Run the sample tutorial provided with Apptivity. The tutorial
is located in <INSTALL DIR>\samples\Tutorial.
2. Click on the Update Supplier tab
3. Click on the QBF button on the Navigation Toolbar. It is the
button on the far right on the toolbar. All the fields will
blank out.
4. Enter your search pattern - for example enter E% in the
Company Name field. Hit the apply filter button (again, the
same as the QBF button, on the far right of the toolbar).
5. The fields are populated again but now only records that
satisfy the filter are displayed. If you used E%, only Exotic
Liquids and Escargots Nouveaux records are displayed when you
navigate through the data source.
For more information on QBF please see the Apptivity Developers
Guide in the chapter entitled "Using the Navigation Bar".
Progress Software Technical Support Note # 17690