All field values, both hidden and displayed, are written to the file. The DbTool allows you to specify the fields that you wish a select to sort on. These fields will be placed in the order by clause of the query. Double clicking on a field in the left column will transfer it to the right. Double clicking on a field in the right column will delete it from the list of sort fields.
Sort order is from top to bottom.
After the sort list has been updated, all later selects will use this sort list. At present, it is the user's responsibility to make sure that only one occurrence of a field name is in the sort list. The DbTool provides a user with the database functions that are enabled via database privileges. The use of each of these functions are described in the following subsections. The select option enables a user to retrieve information from the database that match specified query constructs.