To create a simple database query

  1. Log in to Query Builder.

    The initial Query Builder form is displayed.

  2. In the left pane of the Query Builder, locate the object or objects required for the query, for example, one or more fields from a file.
  3. To create a query for all fields in a file, double-click the file. To create a query for selected fields, double-click individual fields or click each field, then right-click and select Select Field. You can use Ctrl-click to select multiple fields, then right-click, and then select Select Fields.)
  4. Review the query in the lower right pane of the Query Builder.
  5. Click Execute to test the query.

    If the query has problems and the problems are not evident, you might want to set Execution Logging to Server Calls to Log File. See Execution Logging.

  6. Save the query.
  7. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.