Difference between revisions of "SQL Remote Data Connectivity Functions"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Remote data connectivity functions | Remote data connectivity functions | ||
| Line 30: | Line 23: | ||
|- | |- | ||
|[[SQLDISCONNECT()]]||Disconnect from 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 | |[[SQLEXEC()]]||Send an SQL statement to a data source | ||
| Line 52: | Line 47: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
[[Category:SQL|Remote Data Connectivity Functions]] | [[Category:SQL|Remote Data Connectivity Functions]] | ||
| + | [[Category:Remote Data Connectivity]] | ||
| + | [[Category:Remote Data Connectivity Functions]] | ||
Latest revision as of 16:13, 4 July 2011
Contents
Purpose
Remote data connectivity functions
See Also
CREATE CONNECTION, INSERT, SELECT, SELECT
Description
The Visual FoxPro compatible remote data connectivity functions are used to handle gateway connections to third party data 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 using a gateway connection string |
| SQLTABLES() | Store data source table names to a table |
Products
Recital, Recital Server
