Language Reference for OLE DB Development

The Visual FoxPro OLE DB Provider supports the native Visual FoxPro language syntax for the following commands:

• CREATE TABLE - SQL Command
  Creates a table having the specified fields.
• DELETE - SQL Command
  Marks records for deletion.
• DROP TABLE Command
  Removes a table from the database specified with the data source and deletes it from disk.
• INSERT - SQL Command
  Appends a record to the end of a table that contains the specified field values.
• SELECT - SQL Command
  Retrieves data from one or more tables.
• UPDATE - SQL Command
  Updates records in a table with new values.

The Visual FoxPro Language Reference contains detailed information about the following supported commands:

• ALTER TABLE - SQL Command
  Programmatically modifies the structure of a table.

• CREATE TABLE - SQL Command
  Creates a table having the specified fields.

• DELETE - SQL Command
  Marks records for deletion.

• DELETE TAG Command
  Removes a tag or tags from a compound index (.cdx) file.

• DROP TABLE Command
  Removes a table from the database specified with the data source and deletes it from disk.

• INDEX Command
  Creates an index file to display and access table records in a logical order.

• INSERT - SQL Command
  Appends a record to the end of a table that contains the specified field values.

• SELECT - SQL Command
  Retrieves data from one or more tables.

  The Visual FoxPro OLE DB Provider supports the native Visual FoxPro language syntax for this command.

• SET ANSI Command
  Determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands.

• SET BLOCKSIZE Command
  Specifies how disk space is allocated for the storage of memo fields.

• SET COLLATE Command
  Specifies a collation sequence for character fields in subsequent indexing and sorting operations.

• SET DELETED Command
  Specifies whether records marked for deletion are processed and whether they are available for use in other commands.

• SET EXACT Command
  Specifies the rules for comparing two strings of different lengths.

• SET EXCLUSIVE Command
  Specifies whether table files are opened for exclusive or shared use on a network.

• SET NULL Command
  Determines how null values are supported by the ALTER TABLE - SQL, CREATE TABLE - SQL, and INSERT - SQL commands.

• SET PATH Command
  Specifies a path for file searches.

• SET REPROCESS Command
  Specifies how many times or for how long to lock a file or record after an unsuccessful locking attempt.

• SET UNIQUE Command
  Specifies whether records with duplicate index key values are maintained in an index file.

• UPDATE - SQL Command
  Updates records in a table with new values.

See Also

Visual FoxPro OLE DB Provider Data Support | Supported Visual FoxPro SET Commands | Supported Visual FoxPro Commands and Functions | Unsupported Visual FoxPro Commands and Functions | Mapping Visual FoxPro ODBC driver functions to OLE DB methods | Supported OLE DB Objects | Standard and Custom OLE DB Properties | OLE DB Provider for Visual FoxPro