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 10: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 |
