|
  |
|
|
| Contents | Index ODBC Query The ODBC Query Feature will allow any ODBC data source to be accessed and data brought into the program for read-only analysis. The "query definition" will be stored as part of a regular QDB file, and can be subsequently re-run to obtain a current set of data. The "query results" data will appear much like normal columns in the SPC data set. The Data menu offers the following options associated with ODBC queries. The first option is always available; the remaining choices are only available when the data editor is the current window and the data file has an ODBC query attached to it. New ODBC Query: See Creating an ODBC Query Amend ODBC Query: Opens the Define Query dialog box Refresh ODBC Query: See Updating Queries Delete ODBC Query: When historical data has been extracted from a database through a query, and this data is not likely to change, you may have no need for refreshing or updating the query results. In this case, you may save the query results with the file, and delete the query. Query results currently within the file will remain intact and may be saved with the data file. |
|
|
