Supported ODBC SQL Grammar (Visual FoxPro ODBC Driver)
The Microsoft Visual FoxPro ODBC Driver supports the following:
All SQL statements and clauses in the ODBC minimum SQL grammar
An additional SQL statement from the ODBC core SQL grammar
The following table lists the items supported by the driver, by ODBC SQL Grammar level.
| Level | Elements | Item |
|---|---|---|
| Minimum | Data Definition Language (DDL) | CREATE TABLE and DROP TABLE |
| Data Manipulation Language (DML) | SELECT, INSERT, UPDATE, and DELETE | |
| Expressions | Simple (such as A>B+C) | |
| Data types | CHAR, VARCHAR, or LONG VARCHAR |
In addition to the supported ODBC SQL grammar, the Visual FoxPro ODBC Driver supports the complete native Visual FoxPro language syntax for the following Visual FoxPro commands: