ODBC Queries are used to view data from database applications, making it an extremely powerful feature. From the Data menu, select New ODBC Query, then choose to either add the results of the query to a new Data Editor window or to the current Data Editor window.
From the Define Query dialog box, you specify which tables in the database have data of interest to you, as well as criteria (or conditions) to limit the data that is queried from those tables. The example shown below limits the query to only the data from Dr. Allan in Operating Room 12.
Using the Automatic Refresh option, the database is automatically checked at the specified interval for new or edited data. If you want to save a snapshot of the data with the .qdb file, use the Save Query Results with File feature; otherwise, only the Query statement is saved with the file, and refreshed with current data when the file is opened.
