Special SQL Keywords for Support of OLE DB Functionality

Special keywords are supported when defining a query. Special keywords are easily recognizable because they are placed in brackets.

Placing the target name of a column in brackets, as in [Product], specifies that it should be replaced by the value on the column with the Target Name Product when the SQL statement is executed. For example, consider the following SQL statement:

SELECT UCL, LCL, Center FROM Specs WHERE Date = [Product]

The above SQL statement would be useful as a query to fetch specifications for a particular product. If the Product column is included in the main query that returns the measurements and is assigned the Target Name Product, it can be used in the above manner. If end users can filter interactively by product before the query is executed, it is possible to specify a wildcard that is replaced by the product or products selected by the user.

A second available keyword is [CROSSTAB_COLUMN_VALUE]. When a crosstab query is specified, the set of unique values on the column with the target type Crosstab Column is not known until run-time. The above wildcard will be replaced with the value or values in the crosstab column when the query is executed.