Difference between revisions of "Remote Data Connectivity"

From Recital Documentation Wiki
Jump to: navigation, search
(Processing Result Sets)
(Processing Result Sets)
Line 99: Line 99:
 
* [[RDO_FIELD_SEEK()|rdo_field_seek()]] - jump to a specified field in a result set
 
* [[RDO_FIELD_SEEK()|rdo_field_seek()]] - jump to a specified field in a result set
  
 
+
=====Freeing Memory=====
 
* [[RDO_FREE_OBJECT()|rdo_free_object()]] - free memory used by a result set object
 
* [[RDO_FREE_OBJECT()|rdo_free_object()]] - free memory used by a result set object
 
* [[RDO_FREE_RESULT()|rdo_free_result()]] - free memory used by a result set object
 
* [[RDO_FREE_RESULT()|rdo_free_result()]] - free memory used by a result set object

Revision as of 14:42, 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])
numeric = rdo_select_db(database as character [, connection as numeric])

Disconnecting from a Data Source

numeric = rdo_close(connection as numeric)

Sending SQL Queries and Statements

numeric = rdo_exec(statement as string [, connection as numeric])
  • rdo_query() - return a result set object for a SELECT query
object = rdo_query(query as string [, connection as numeric])
object = rdo_unbuffered_query(query as string [, connection as numeric])
string = rdo_real_escape_string(query as string [, connection as numeric])
numeric = rdo_affected_rows()
  • rdo_info() - return information about the last query
string = rdo_info()

Processing Result Sets

Freeing Memory

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

Examples

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2