Form dialog

A form dialog is generated by entering a query in the Visual SQL Query Builder dialog box's SQL Select Statement text field and clicking Execute. An existing form dialog is opened from the Visual SQL Query Builder dialog box by choosing Open or Edit from the Forms menu. A form dialog indicates how many records were obtained with the query generated in the Visual SQL Query Builder dialog box, and displays record number 1 of the query results.

It also includes controls to easily interface with the database in order to query it, add records to it, or to update it.


A form dialog obtained from a query of the highway table

Query result section

(not labeled) The query result for the fields selected in the <TABLENAME> dialog box appear in the query result section (the top section) of a database dialog form.

Also displayed is identification of which of the query result records is being displayed, if Count Row Label is on in the Standard Form Items dialog box. For example, “#3 of 16” indicates that the query resulted in 16 records and the third record is displayed in the query result section.

Query

Executes queries, by typing an SQL statement into the Query text box or by entering values in the form dialog text fields, and then clicking Query.

Insert

Adds a new database record to the end of the table.

Update

Updates field values of the currently displayed row. Click a field value, type in the new value and click Update.

Delete

Deletes the currently displayed row.

Clear

Clears the values in the currently displayed row. The values are not deleted from the database, however.

First

Navigates to the first row of the query results.

Navigates to the previous row of the query results.

Navigates to the next higher of the query results.

Last

Navigates to the last row (highest numbered) of the query results.

Attach

Used to attach the current database record, as displayed in the list box, to a graphics element or to all elements within a fence.

Review

Displays a database record linked with an element that you identify on the screen, if you select an element which is of the same type as the form dialog. For example, if you have a MONUMENT form dialog open, you must identify a monument on you screen in order to retrieve the monument's database record.

The Review Attributestool (key in: REVIEW) will return the database record regardless of which linked element is identified. If you click Review in a VSQL form dialog however, the Review command will return database records only if you identify an element which has a database linkage to the table from which the form dialog was built. The name at the top of the form dialog identifies the table.

Detach

Used to detach the current database record.

Locate

Used to locate a an element or area linked to the currently displayed database record. It centers and highlights the element in the selected view. For Locate to work, your query must include MSLINK.

If the element is not present in the currently opened design file, an informational dialog box opens with the message “No element linked in the current row”. The Locate command looks for the record's element in the current design file, and displays the record if it is found.

Use Fence If Active

If on, the fence is used for processing. This control appears if the Use Fence Toggle is turned on in the Standard Form Items dialog box. There are three possibilities:

Use Fence If Active is not present (on a form dialog)–clicking Review works in conjunction with a fence, if one is placed.
Use Fence If Active is present and on–Review works in conjunction with fence if one is placed.
Use Fence If Active is present and off–Review ignores any fence that is placed.