Difference between revisions of "Remote Data Connectivity"

Revision as of 15:07, 28 July 2010 (view source) Yvonnemilne (Talk | contribs) (→‎Processing Result Sets) ← Older edit		Revision as of 15:09, 28 July 2010 (view source) Yvonnemilne (Talk | contribs) (→‎Sending SQL Queries and Statements) Newer edit →
Line 58:		Line 58:
	<pre>		<pre>
	object = rdo_unbuffered_query(query as string [, connection as numeric])		object = rdo_unbuffered_query(query as string [, connection as numeric])
		+	</pre>
		+
		+	* [[RDO_FETCH_ARRAY()|rdo_fetch_array()]] - return the results of a query as an associative array
		+
		+	<pre>
		+	array = rdo_fetch_array(query as string)
		+	</pre>
		+
		+	* [[RDO_FETCH_ASSOC()|rdo_fetch_assoc()]] - return the results of a query as an associative array
		+
		+	<pre>
		+	array = rdo_fetch_assoc(query as string)
	</pre>		</pre>

---

Revision as of 15:09, 28 July 2010

Remote Data Connectivity

Overview of Remote Data Connectivity Functions

• 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
• sqlmoreresult() - 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

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

• rdo_connect() - connect to a data source

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

• rdo_select_db() - set the active database for a data source connection

numeric = rdo_select_db(database as character [, connection as numeric])

Disconnecting from a Data Source

• rdo_close() - close a data source opened with rdo_connect()

numeric = rdo_close(connection as numeric)

Sending SQL Queries and Statements

• rdo_exec() - execute a non-SELECT statement

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])

• rdo_unbuffered_query() - return a result set object for a SELECT query

object = rdo_unbuffered_query(query as string [, connection as numeric])

• rdo_fetch_array() - return the results of a query as an associative array

array = rdo_fetch_array(query as string)

• rdo_fetch_assoc() - return the results of a query as an associative array

array = rdo_fetch_assoc(query as string)

• rdo_real_escape_string() - escape special characters in a string for use in an SQL statement

string = rdo_real_escape_string(query as string [, connection as numeric])

• rdo_affected_rows() - return the number of rows affected by the last operation

numeric = rdo_affected_rows()

• rdo_info() - return information about the last query

string = rdo_info()

Processing Result Sets

Navigating the Result Set

• rdo_fetch_row() - return the next row from a result set as an object
• rdo_fetch_object() - return the next row from a result set as an object
• rdo_data_seek() - move the internal row pointer
• rdo_field_seek() - jump to a specified field in a result set

Result Set Information

• rdo_fetch_field() - return an object containing information about a field from a result set
• rdo_fetch_lengths() - return the length of the contents of each field in a result set
• rdo_num_fields() - return the number of fields in a result set
• rdo_num_rows() - return the number of rows in a result set

Field Information

• rdo_field_flags() - return the flags of a field in a result set
• rdo_field_len() - return the length of a field in a result set
• rdo_field_name() - return the name of a field in a result set
• rdo_field_type() - return the type of a field in a result set
• rdo_result() - return the value of a field in a result set
• rdo_field_table() - return the name of the table where a specified field is located

Freeing Memory

• rdo_free_object() - free memory used by a result set object

numeric = rdo_free_object(resultset as object)

• rdo_free_result() - free memory used by a result set object

numeric = rdo_free_result(resultset as object)

Getting Error Information

• rdo_errno() - return the number of the last error

numeric = rdo_errno()

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

string = rdo_errno()

Getting Environment Information

• rdo_get_client_info() - return information about the client

string = rdo_get_client_info()

• rdo_get_host_info() - return information about the connection

string = rdo_get_host_info(connection as numeric)

• rdo_list_dbs() - list the available databases for the current or specified connection

object = rdo_list_dbs([connection as numeric])

• rdo_ping() - check whether a server connection is active

logical = rdo_ping(connection as numeric)

• rdo_stat() - return the current system status of Recital

numeric = rdo_stat(connection as numeric)

• rdo_thread_id() - return the current thread ID

numeric = rdo_thread_id([connection as numeric])

Examples

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2