The VPM Enterprise Condition Builder is an interface used with the Form Toolbar Locate, Filter and Group Delete controls and the Report Setup dialog’s For and While options (see Using the Report Setup Dialog).
The Condition Builder allows you to construct simple and complex conditions to locate, filter or delete records in the tables or views used by a form. The Condition Builder lets you create conditions to select the records that will appear in a report.
The Condition Builder allows users to store, maintain and recall a library of frequently used conditions for each form and report. What's more if you turn on User Access Security, each user can build their own library of conditions. In short, you can create condition libraries by form, report and user.
Users can be given the permission to create “global” conditions that will appear in the Condition Builder for all users. When users bring up the Condition Builder, they see and can use the conditions that they have created as well as the global conditions created by others.
Global Conditions Add/Edit Permission: A user is granted permission to add and edit global conditions on the Users form reached from the Users option on the Admin - Security menu (see Users). On the User’s form, check the Global Conditions Add/Edit check box if the user should have the right to create global conditions that will appear in the Condition Builder for all users. When a user that has the global add/edit permission saves a condition, the user is prompted to save the condition as a global condition.
A user that does not have the global add/edit permission cannot remove or edit global conditions. The Remove condition button and all Modify Condition controls will be disabled when a global condition is selected.
How to Use the Condition Builder
The Condition Builder provides a list of fields selected by the developer from the tables, views and CursorAdapters in a form’s or report’s Data Environment. You build a new condition by building condition statements from the fields provided. To build a condition statement, you select a field from the Condition Builder’s Field list, select an operator (such as, “equal to”, “less than”, etc.) that compares a value to the field, and enter the value for the comparison. The “How You Use the Condition Builder” section below provides step-by-step instructions for using the Condition Builder.
How to Build the Fields List
You build the list of fields provided by the Condition Builder when you create a form or report.
· Forms: At any time after you enter a unique name in the Name property of a form and set up the Data Environment for a form, you can use the ProMatrix Condition Field List Builder to select the fields that will appear in the form’s Condition Builder Field list. See ProMatrix Condition Field List Builder on page 372 to learn how to select the tables, views, CursorAdapters and fields for a form’s Condition Builder.
Tip: You need to enter a unique name in a form’s Name property before running the Condition Field List Builder. VPME uses a form’s unique Name to keep track of the fields you select for the form’s Condition Builder Field list. If you change the Name after running the Condition Field List Builder, you’ll have to run the Builder again to reselect the form’s Condition Builder fields.
If you don’t use the ProMatrix Condition Field List Builder for a form, the Condition Builder Field list for the form will default to all the fields in the InitialSelectedAlias table, view or CursorAdapter.
· Reports: You use the Report Setup Options dialog to select the fields that will appear in the report’s Condition Builder Field list. See Report Setup Options to learn how to select the tables, views and fields for a report’s Condition Builder. If you don’t set up the Condition Builder for a report, the Condition Builder for the report won’t have any fields to select when it appears.