Difference between revisions of "Remote Data Connectivity"

From Recital Documentation Wiki
Jump to: navigation, search
(Overview of Remote Data Connectivity Functions)
(Overview of Recital Data Objects (RDO))
Line 16: Line 16:
  
 
===Overview of Recital Data Objects (RDO) ===
 
===Overview of Recital Data Objects (RDO) ===
 +
Returns a row from a recordset as an associative array
 +
Object = rdo_fetch_array(query as Character)
 +
Object = rdo_fetch_assoc(query as Character)
 +
Object = mysql_fetch_array(query as Character)
 +
Object = mysql_fetch_assoc(query as Character)
 +
 +
This function returns a ResultSet Object for SELECT queries
 +
Object = rdo_query(query as Character [, connection as Numeric] )
 +
Object = rdo_unbuffered_query(char query [, connection as Numeric] )
 +
Object = mysql_query(query as Character [, connection as Numeric] )
 +
Object = mysql_unbuffered_query(char query [, connection as Numeric] )
  
 
===Using Recital Client/Server ===
 
===Using Recital Client/Server ===

Revision as of 15:29, 18 March 2010

Remote Data Connectivity

Overview of Remote Data Connectivity Functions

  • SQLCANCEL()
  • SQLCOLUMNS()
  • SQLCOMMIT()
  • SQLCONNECT()
  • SQLDISCONNECT()
  • SQLEXEC()
  • SQLGETPROP()
  • SQLMORERESULTS()
  • SQLPREPARE()
  • SQLROLLBACK()
  • SQLSETPROP()
  • SQLSTRINGCONNECT()
  • SQLTABLES()

Overview of Recital Data Objects (RDO)

Returns a row from a recordset as an associative array Object = rdo_fetch_array(query as Character) Object = rdo_fetch_assoc(query as Character) Object = mysql_fetch_array(query as Character) Object = mysql_fetch_assoc(query as Character)

This function returns a ResultSet Object for SELECT queries Object = rdo_query(query as Character [, connection as Numeric] ) Object = rdo_unbuffered_query(char query [, connection as Numeric] ) Object = mysql_query(query as Character [, connection as Numeric] ) Object = mysql_unbuffered_query(char query [, connection as Numeric] )

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2