SQLExecDirect (Visual FoxPro ODBC Driver)

  • Article

Note

This article contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate article under ODBC API Reference.

Support

Full.

ODBC API conformance

Core level.

Remarks

Executes a new, preparable SQL statement. The Visual FoxPro ODBC Driver uses the current values of the parameter marker variables if any parameters exist in the statement.

To create a batch command to submit more than one SQL statement at a time, use a semicolon (;) to separate each SQL statement in the batch.

If your table, view, or field names contain spaces, enclose the names in back quote marks. For example, if your database contains a table named My Table and the field My Field, enclose each element of the identifier as follows:

SELECT `My Table`.`Field1`, `My Table`.`Field2` FROM `My Table`;

For more information, see SQLExecDirect Function in the ODBC Programmer's Reference.