Promis.e Help

Database Form Dialogs

Promis.e VSQL supports database operations including query, update, review, and geolocate using dynamically definable database dialog forms. These forms are generated using the Visual SQL Query Builder. Database form dialog controls allow users to create, edit and save database forms after first interactively defining form contents and dialog controls.

Database forms support row navigation operations, including find first row, last row, next row, previous row, and row count. Database update and query operations include query execute, row insert, row update, and row delete. Database forms support integrated database and graphics operations including database review, and locate. The form may also be used to attach and detach linkages from graphical elements.

After generating the form, the user can customize the organization of the form and associated controls using the visual editing tools in the Visual SQL Query Builder. Individual dialog controls can optionally be set to read-only in the case that forms are intended to support query operations only. (This is accomplished by selecting Forms from the Settings menu, and turning off Insert Row Button, Delete Row Button and Update Row Button.) Once a form has been created it can be used to query and review database attributes using "query by example" functions that allow users to enter values and operators (">", "<") directly into form fields.

Only the columns selected in the <TABLENAME> dialog appear in the results section of a database dialog form. Instead of getting all rows in a table, the form dialog provides only the fields needed by the user. This ability to customize data display and editing enhances user productivity by reducing the quantity of data to a manageable scale. The control of database resources in this way enables the transformation of raw data into useful information.

You can minimize or dismiss the Visual SQL Query Builder after executing a query, leaving the form dialog active.

Note: The following procedure assumes that your form dialog contains all possible items.