MicroStation CONNECT Edition Help

Visual SQL Query Builder Dialog, OrderBy Tab

Used to sort query results.



SettingDescription
Selected Table(s) Displays the table being processed in generating a query.
Available Fields Displays the fields of the table displayed in the Table dialog.
Note: If there are joined tables selected, the table's alias appears in front of each field's name, to distinguish fields from different tables.
OrderBy Field Enter the field by which you want your query results sorted. Double-clicking a field in Available Fields copies it into the OrderBy Field text box.
Descending When on, selects sorting in descending order. When off (the default setting), selects sorting in ascending order.
Clear Deletes the contents of the OrderBy Field text box.
Apply Copies the ORDER BY clause generated in the OrderBy tab page into the SQL Select Statement text box.