SQLPrepare (Visual FoxPro ODBC Driver)
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
Prepares a SQL statement by planning how to optimize and execute the statement. The SQL statement is compiled for execution by SQLExecDirect.
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 * FROM `My Table`.`My Field`
For more information, see SQLPrepare Function in the ODBC Programmer's Reference.