Progress
AppBuilder
Developer’s Guide
Where Mode
To specify search criteria for a table, activate the Where radio-set button in the Query Builder dialog box. The Query Builder enters Where mode and appears as in Figure 4–9.
Figure 4–9: Query Builder in Where Mode
![]()
First, select a field from the list of fields. The AppBuilder displays the possible comparison operators for that field. These operators are sensitized based on the type of field.
For example, if you select the Cust-num field, the Contains button is not sensitized because Cust-num is not a word-indexed field. Also, Begins and Matches are not sensitized either, because Cust-num is an integer field.
After you select a field, choose one of the enabled comparison buttons. A dialog box appears that lets you supply a constant for comparison (you cannot specify variables). If you choose either the List or Range button, the dialog boxes that appear allow you to specify whether the list or range is inclusive or exclusive. The AND and OR buttons extend the relationships between logical fields and also let you combine logical phrases with a complex expression.
The AppBuilder displays the 4GL text of the clause in the Where Criteria editor. When you choose OK, the AppBuilder displays the code in the Query Builder when it is in Table mode, and in the widget’s property sheet if the query is an embedded one.
If you are familiar with the Progress 4GL, you can type the search criteria directly into the Where Criteria panel.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |