Difference between revisions of "SQL Remote Data Connectivity Functions"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 57: Line 57:
 
[[Category:Reference]]
 
[[Category:Reference]]
 
[[Category:SQL|Remote Data Connectivity Functions]]
 
[[Category:SQL|Remote Data Connectivity Functions]]
 +
[[Category:Data Connectivity]]
 +
[[Category:Data Connectivity Functions]]

Revision as of 04:50, 15 June 2009

REMOTE DATA CONNECTIVITY FUNCTIONS

Class

SQL Applications


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
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 Database Server, Recital Mirage Server, Recital Terminal Developer