Difference between revisions of "Remote Data Connectivity"

From Recital Documentation Wiki
Jump to: navigation, search
(Overview of Recital Data Objects (RDO))
(Connecting to a Data Source)
Line 22: Line 22:
 
====Connecting to a Data Source====
 
====Connecting to a Data Source====
 
* [[RDO_CONNECT()|rdo_connect()]] - connect to a data source
 
* [[RDO_CONNECT()|rdo_connect()]] - connect to a data source
 +
 +
<pre>
 +
numeric = rdo_connect(servertype as character, hostname_or_ip as character, account as character, password as character [, database as character])
 +
</pre>
 +
 
* [[RDO_SELECT_DB()|rdo_select_db()]] - set the active database for a data source connection
 
* [[RDO_SELECT_DB()|rdo_select_db()]] - set the active database for a data source connection
  

Revision as of 13:55, 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.

Connecting to a Data Source

numeric = rdo_connect(servertype as character, hostname_or_ip as character, account as character, password as character [, database as character])

Disconnecting from a Data Source

Sending SQL Queries and Statements

Processing Result Sets

Getting Error Information

  • rdo_errno() - return the number of the last error
  • rdo_error() - return the error description of the last Recital error

Getting Environment Information

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2