Supported ODBC SQL Grammar (Visual FoxPro ODBC Driver)

  • Article

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:

ALTER TABLE

CREATE TABLE

DELETE

DELETE TAG

DROP TABLE

INDEX

INSERT

SELECT

UPDATE