How To Use the FoxPro SQLPrepare() Function (156061)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 6.0
  • Microsoft Data Access Components 2.5
This article was previously published under Q156061

SUMMARY

This article discusses what is required in order to use the FoxPro SQLPrepare() function.

MORE INFORMATION

In order to use the FoxPro SQLPrepare() function, the ODBC driver must support the ODBC API SQLPrepare() function. In theory, this should include all ODBC drivers because SQLPrepare() is a requirement for ODBC API Core conformance. However, depending on the ODBC driver and the capabilities of the server, SQLPrepare() may not do anything. For example, no preparation of the statement takes place, but it is saved to be executed on SQLExecute().
Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbDatabase kbhowto kbinterop KB156061
©2004 Microsoft Corporation. All rights reserved.