Difference between revisions of "SQL Remote Data Connectivity Functions"
From Lianjapedia
Barrymavin (Talk | contribs) |
Barrymavin (Talk | contribs) (→Description) |
||
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | {{DISPLAYTITLE:Working with ODBC}} | ||
+ | [[Category:Database Stored Procedures]] | ||
==Purpose== | ==Purpose== | ||
Remote ODBC data connectivity functions | Remote ODBC data connectivity functions | ||
Line 4: | Line 6: | ||
<div style="margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | <div style="margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | ||
[[File:bm-noteicon.png|top|40px|link=]]<div style="position:absolute;top:3px;margin-bottom;bottom:5px;margin-left:50px;"><b> Pro Tip</b> | [[File:bm-noteicon.png|top|40px|link=]]<div style="position:absolute;top:3px;margin-bottom;bottom:5px;margin-left:50px;"><b> Pro Tip</b> | ||
− | You can use [[Virtual_Tables|Virtual Tables]] to work seamlessly with external SQL databases. | + | You can also use [[Virtual_Tables|Virtual Tables]] to work seamlessly with external SQL databases. |
</div> | </div> | ||
<span style="height:6px;"> </span> | <span style="height:6px;"> </span> | ||
</div> | </div> | ||
− | + | ||
==See Also== | ==See Also== | ||
− | [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE| | + | [[SQL INSERT|SQL INSERT]], [[SQL SELECT|SQL SELECT]], [[SQL UPDATE|SQL UPDATE]], [[SQL_DELETE|SQL DELETE]] |
==Description== | ==Description== | ||
Line 56: | Line 58: | ||
[[Category:ODBC Functions]] | [[Category:ODBC Functions]] | ||
[[Category:SQL Functions]] | [[Category:SQL Functions]] | ||
+ | [[Category:Databases]] | ||
+ | [[Category:Data Integration]] |
Latest revision as of 11:49, 10 May 2024
Purpose
Remote ODBC data connectivity functions
Pro Tip
You can also use Virtual Tables to work seamlessly with external SQL databases.
See Also
SQL INSERT, SQL SELECT, SQL UPDATE, SQL DELETE
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 |