Difference between revisions of "SQL Remote Data Connectivity Functions"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 35: | Line 35: | ||
|[[SQLSETPROP()]]||Set property settings for a connection | |[[SQLSETPROP()]]||Set property settings for a connection | ||
|- | |- | ||
| − | |[[SQLSTRINGCONNECT()]]||Connect to a data source | + | |[[SQLSTRINGCONNECT()]]||Connect to a data source |
|- | |- | ||
|[[SQLTABLES()]]||Store data source table names to a table | |[[SQLTABLES()]]||Store data source table names to a table | ||
Revision as of 11:59, 19 December 2012
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 |
