MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

SQLPrepare

Support: Full  
ODBC API Conformance: Core Level

Prepares an 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 in the ODBC Programmer's Reference.