Remote Data Connectivity

From Recital Documentation Wiki
Revision as of 15:29, 18 March 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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