SQLPrepare (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

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.