Difference between revisions of "SQL Remote Data Connectivity Functions"
From Lianjapedia
Barrymavin (Talk | contribs) (→Purpose) |
Barrymavin (Talk | contribs) |
||
Line 1: | Line 1: | ||
+ | DISPLAYTITLE:ODBC Data Connectivity Functions}} | ||
==Purpose== | ==Purpose== | ||
Remote ODBC data connectivity functions | Remote ODBC data connectivity functions |
Revision as of 11:54, 13 December 2017
DISPLAYTITLE:ODBC Data Connectivity Functions}}
Purpose
Remote ODBC 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 |