| title | SQLPrepare (Visual FoxPro ODBC Driver) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 0c4cb5a4-9729-4b2e-a0c6-52027b92e8fc | |
| author | David-Engel | |
| ms.author | v-daenge |
Note
This topic contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
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.