MDAC 2.5 SDK - Visual FoxPro ODBC Driver

Supported ODBC SQL Grammar

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: