Query Options

Use SQL statement or WHERE clause to return no data
Some OLE DB providers cannot return the field types without actually running the query, and this can be time consuming. Selecting this check box enables you to modify the SQL statement so that no data will be returned. For example, if you type "1 > 2" in the text box below the check box, the clause "where 1>2" will be appended to the SQL statement. The text box is only available when the check box is selected.
Parameterization
Select this check box to allow the SQL statement to contain optional parameters when running Data Configurations through a customized user interface (using Statistica Enterprise object model). These parameters must have the syntax ${number}.

For example, the user has the following query:

SELECT * FROM MYTAB

The user, through the customized interface, wants to add a further WHERE clause to the SQL statement, but does not want to hard code it in the Query. The SQL statement can be edited to include a parameter:

SELECT * FROM MYTAB ${1}

The customized user interface can then call upon the Statistica Enterprise object model to edit this statement when running the Data Configuration:

Dim oAnalysisRunOption as New SWLMonitorService.MonitorRunOption

oAnalysisRunOption.Add "profile.query.My Query.param.1", "WHERE ColA > 100"

Where the Query name was defined as "My Query". So when this is run, it will run the query:

SELECT * FROM MYTAB WHERE ColA > 100

Timestamp workaround
Select this check box when using Microsoft Jet OLE DB providers or connecting through ODBC to an Access database to use MS Jet specific date/time formatting (i.e., '2008-01-01 00:00:00').
OK
Click this button to accept any changes you have made and exit the dialog box.
Cancel
Click this button to exit the dialog box without making any changes.