To create a simple database query

  1. Log in to Query Builder.

    The initial Query Builder form appears.

  2. In the left pane of the Query Builder, locate the object or objects that you want to 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 also can select multiple fields by using Ctrl-click, then right-click, and then selecting 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 obvious, you might want to set Execution Logging to Server Calls to Log File. See Execution Logging for more information.

  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.