MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Support: Full
ODBC API Conformance: Core Level
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 in the ODBC Programmer's Reference.