Wiki Home

Visual FoxPro SQL

Namespace: WIN_COM_API
Visual FoxPro supports a subset of StructuredQueryLanguage (SQL).

I'd like to know exactly what part(s) of SQL VFP does not support.

Visual FoxPro supports the following Data Manipulation Language (DML) commands.

Select SQL
Update SQL
Delete SQL
Insert SQL

Visual FoxPro supports the following DataDefinitionLanguage (DDL) commands.

Create Table SQL
Alter Table SQL
Drop Table SQL
While it may support most SQL commands, VFP's SQL parser needs to be enhanced. It does not handle simple nested sub-queries.

VFP's implementation of ANSI SQL does support sub-queries but only in the WHERE clause - Michael Levy
Category VFP Commands
( Topic last updated: 1999.11.18 03:07:47 PM )