SQL Remote Data Connectivity Functions
From Lianjapedia
Revision as of 10:09, 31 January 2013 by Helen.george (Talk | contribs)
Purpose
Remote data connectivity functions
See Also
Description
The Visual FoxPro compatible remote data connectivity functions are used to handle connections to ODBC sources. The following functions are available:
Function | Description |
---|---|
SQLCANCEL() | Request that an executing SQL statement be cancelled |
SQLCOLUMNS() | Store column information to a cursor |
SQLCOMMIT() | Commit a transaction |
SQLCONNECT() | Connect to a data source |
SQLDISCONNECT() | Disconnect from a data source |
SQLERROR() | Return descriptive message for last error |
SQLEXEC() | Send an SQL statement to a data source |
SQLGETPROP() | Query property settings for a connection or the environment |
SQLMORERESULTS() | Check if more results sets are available and if so, copy next results set to a cursor |
SQLPREPARE() | Prepare an SQL statement that will be executed by the SQLEXEC() function |
SQLROLLBACK() | Rollback a transaction |
SQLSETPROP() | Set property settings for a connection |
SQLSTRINGCONNECT() | Connect to a data source |
SQLTABLES() | Store data source table names to a table |
SQLTRANSACTION() | Start a transaction |