Difference between revisions of "Remote Data Connectivity"

From Recital Documentation Wiki
Jump to: navigation, search
(Overview of Recital Data Objects (RDO))
(Overview of Recital Data Objects (RDO))
Line 15: Line 15:
 
* [[SQLTABLES()|sqltables()]] - store data source table names to a table
 
* [[SQLTABLES()|sqltables()]] - store data source table names to a table
  
===Overview of Recital Data Objects (RDO) ===
+
===Overview of Recital Data Objects (RDO)===
 +
The RDO functions can be used for data access for both remote third-party/Recital and local Recital data sources.  The functions allow a connection to be made to the data, SQL queries to be sent and the results to be loaded into a '''result set''' object for further processing.
 +
 
 +
Each MySQL compatible RDO function also has a MySQL-named equivalent for ease of use, e.g. [[RDO_CONNECT()|rdo_connect()]] and [[RDO_CONNECT()|mysql_connect()]] are synonyms.
 +
 
 +
 
 
* [[RDO_AFFECTED_ROWS()|rdo_affected_rows()]] - return the number of rows affected by the last operation
 
* [[RDO_AFFECTED_ROWS()|rdo_affected_rows()]] - return the number of rows affected by the last operation
 
* [[RDO_CLOSE()|rdo_close()]] - close a data source opened with [[RDO_CONNECT()|rdo_connect()]]
 
* [[RDO_CLOSE()|rdo_close()]] - close a data source opened with [[RDO_CONNECT()|rdo_connect()]]

Revision as of 13:31, 28 July 2010

Remote Data Connectivity

Overview of Remote Data Connectivity Functions

Overview of Recital Data Objects (RDO)

The RDO functions can be used for data access for both remote third-party/Recital and local Recital data sources. The functions allow a connection to be made to the data, SQL queries to be sent and the results to be loaded into a result set object for further processing.

Each MySQL compatible RDO function also has a MySQL-named equivalent for ease of use, e.g. rdo_connect() and mysql_connect() are synonyms.


Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2