Global Options

Select Global Options from the Edit menu to display the Global Options dialog box. Use these options to specify properties for all queries created in Statistica Query. If you want a specific query to have different options then your default global settings, use the Query Properties dialog box.

Default query properties. The options in the Default query properties group box will be the default query settings for all future queries that are created (but not previously saved queries).

Build full-qualified SQL statement. Select this check box to display the full-qualified SQL statement when you choose to view the SQL statement. This means that the specific database name and/or path will be included in the SQL statement. If this check box is not selected, then this data will not be included in the SQL statement. You can view the SQL statement by selecting the SQL Statement tab or by switching to Text mode (by toggling the toolbar button or the Graphic Mode option on the View menu).

Quote catalog names/Quote schema names/Quote table names/Quote field names. These options determine whether references to database objects in the SQL statements generated are to be enclosed in quotation marks. For most database drivers, the default option is applicable. For certain drivers, placing catalog, schema, table, and field names in quotation marks causes an SQL error. If you do not want quotation marks around these names in the SQL statement, clear the check boxes. You can view the SQL statement by selecting the SQL Statement tab or by switching to Text mode (by toggling the toolbar button or the Graphic Mode option on the View menu).

Use ANSI join syntax. If you need ANSI-92 join syntax on queries, select this option. By default this option isn't selected. ANSI-92 allows you to use INNER JOIN and OUTER JOIN syntax on the FROM clause. Some databases may require this option.

Check SQL statement before running. Select this check box (the default mode) to check the SQL statement for errors before the query is run.

SQL statement syntax. The options in the SQL statement syntax group box are used to specify the syntax for which the SQL statement is based.

Always use ODBC syntax. Select the Always use ODBC syntax option button to generate SQL statements based on the Microsoft ODBC syntax. Make sure that the provider supports ODBC syntax.

Always use SQL92 syntax. Select the Always use SQL92 syntax option button to generate SQL statements based on the ANSI SQL-92 standard syntax. Make sure that the provider supports SQL-92 syntax.

Use syntax based on provider's capability. If you select this option button (the default mode), Statistica Query will make the decision between ODBC or SQL-92 syntax based on the provider's capability.

Some providers have their own syntax and don't support either ODBC or SQL-92. Use the remaining fields for such providers. Note that these fields require you to know how the provider generates SQL statements. For further details on providers, see How do I set up a database connection using the OLE DB provider for ODBC?.

Preview record #. Set this number to be the maximum number of rows displayed within the Preview pane. The default setting of 50 is usually sufficient and typically does not incur performance repercussions.

Automatically preview data. Leave this check box selected if you want dynamically updated and displayed data in the Preview Data pane upon changes/edits to the SQL statement. You may want to clear this check box if it is apparent that updates to the Preview Data pane are slowing performance or if you have no need to preview data.