0 out of 1 rated this helpful - Rate this topic

Additional Supported ODBC SQL Grammar

The ODBC drivers completely support the Minimum ODBC 2.5 grammar and the following clauses in the Core and Extended ODBC 2.5 grammar. Additional information can be displayed by jumping to the ALTER TABLE Statement, Correlation Names, and Procedure Invocation topics.

Approximate numeric literal (Core)
ALTER TABLE Statement (Core)
Binary literals (Extended)
Correlation Names (Core)
Procedure Invocation (Extended)
BETWEEN Predicate (Core)
CREATE INDEX Statement
Date Arithmetic
Jet: Date, Time, and Timestamp Literals
DROP INDEX Statement
Fixed-Width Text File
GROUP BY expression-list
ORDER BY expression-list
ORDER BY with GROUP BY
EXISTS predicate (Core)
IN (valuelist) (Core)
Jet: Outer Joins (Extended)
SELECT statement (Extended) (including GROUP BY, HAVING, and UNION clauses)
Subqueries (SUBSELECTs) (Core)
Scalar Functions
Table Names

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)