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