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 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
+
    * RDO_AFFECTED_ROWS()
Object = rdo_fetch_array(query as Character)
+
    * RDO_CLOSE()
Object = rdo_fetch_assoc(query as Character)
+
    * RDO_CONNECT()
Object = mysql_fetch_array(query as Character)
+
    * RDO_DATA_SEEK()
Object = mysql_fetch_assoc(query as Character)
+
    * RDO_ERRNO()
 
+
    * RDO_ERROR()
This function returns a ResultSet Object for SELECT queries
+
    * RDO_EXEC()
Object = rdo_query(query as Character [, connection as Numeric] )
+
    * RDO_FETCH_ARRAY()
Object = rdo_unbuffered_query(char query [, connection as Numeric] )
+
    * RDO_FETCH_FIELD()
Object = mysql_query(query as Character [, connection as Numeric] )
+
    * RDO_FETCH_LENGTHS()
Object = mysql_unbuffered_query(char query [, connection as Numeric] )
+
    * RDO_FETCH_OBJECT()
 +
    * RDO_FETCH_ROW()
 +
    * RDO_FIELD_FLAGS()
 +
    * RDO_FIELD_LEN()
 +
    * RDO_FIELD_NAME()
 +
    * RDO_FIELD_SEEK()
 +
    * RDO_FIELD_TABLE()
 +
    * RDO_FIELD_TYPE()
 +
    * RDO_FREE_OBJECT()
 +
    * RDO_FREE_RESULT()
 +
    * RDO_GET_CLIENT_INFO()
 +
    * RDO_GET_HOST_INFO()
 +
    * RDO_INFO()
 +
    * RDO_LIST_DBS()
 +
    * RDO_NUM_FIELDS()
 +
    * RDO_NUM_ROWS()
 +
    * RDO_PING()
 +
    * RDO_QUERY()
 +
    * RDO_REAL_ESCAPE_STRING()
 +
    * RDO_RESULT()
 +
    * RDO_SELECT_DB()
 +
    * RDO_STAT()
 +
    * RDO_THREAD_ID()
 +
    * RDO_UNBUFFERED_QUERY()
  
 
===Using Recital Client/Server ===
 
===Using Recital Client/Server ===

Revision as of 14:25, 27 July 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)

   * RDO_AFFECTED_ROWS()
   * RDO_CLOSE()
   * RDO_CONNECT()
   * RDO_DATA_SEEK()
   * RDO_ERRNO()
   * RDO_ERROR()
   * RDO_EXEC()
   * RDO_FETCH_ARRAY()
   * RDO_FETCH_FIELD()
   * RDO_FETCH_LENGTHS()
   * RDO_FETCH_OBJECT()
   * RDO_FETCH_ROW()
   * RDO_FIELD_FLAGS()
   * RDO_FIELD_LEN()
   * RDO_FIELD_NAME()
   * RDO_FIELD_SEEK()
   * RDO_FIELD_TABLE()
   * RDO_FIELD_TYPE()
   * RDO_FREE_OBJECT()
   * RDO_FREE_RESULT()
   * RDO_GET_CLIENT_INFO()
   * RDO_GET_HOST_INFO()
   * RDO_INFO()
   * RDO_LIST_DBS()
   * RDO_NUM_FIELDS()
   * RDO_NUM_ROWS()
   * RDO_PING()
   * RDO_QUERY()
   * RDO_REAL_ESCAPE_STRING()
   * RDO_RESULT()
   * RDO_SELECT_DB()
   * RDO_STAT()
   * RDO_THREAD_ID()
   * RDO_UNBUFFERED_QUERY()

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2