Difference between revisions of "Remote Data Connectivity"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Overview of Remote Data Connectivity Functions) |
Yvonnemilne (Talk | contribs) (→Overview of Recital Data Objects (RDO)) |
||
Line 16: | Line 16: | ||
===Overview of Recital Data Objects (RDO) === | ===Overview of Recital Data Objects (RDO) === | ||
− | * [[RDO_AFFECTED_ROWS()|rdo_affected_rows()]] | + | * [[RDO_AFFECTED_ROWS()|rdo_affected_rows()]] - return the number of rows affected by the last operation |
− | * [[RDO_CLOSE()|rdo_close()]] | + | * [[RDO_CLOSE()|rdo_close()]] - |
− | * [[RDO_CONNECT()|rdo_connect()]] | + | * [[RDO_CONNECT()|rdo_connect()]] - |
− | * [[RDO_DATA_SEEK()|rdo_data_seek()]] | + | * [[RDO_DATA_SEEK()|rdo_data_seek()]] - |
− | * [[RDO_ERRNO()|rdo_errno()]] | + | * [[RDO_ERRNO()|rdo_errno()]] - |
− | * [[RDO_ERROR()|rdo_error()]] | + | * [[RDO_ERROR()|rdo_error()]] - |
− | * [[RDO_EXEC()|rdo_exec()]] | + | * [[RDO_EXEC()|rdo_exec()]] - |
− | * [[RDO_FETCH_ARRAY()|rdo_fetch_array()]] | + | * [[RDO_FETCH_ARRAY()|rdo_fetch_array()]] - |
− | * [[RDO_FETCH_ASSOC()|rdo_fetch_assoc()]] | + | * [[RDO_FETCH_ASSOC()|rdo_fetch_assoc()]] - |
− | * [[RDO_FETCH_FIELD()|rdo_fetch_field()]] | + | * [[RDO_FETCH_FIELD()|rdo_fetch_field()]] - |
− | * [[RDO_FETCH_LENGTHS()|rdo_fetch_lengths()]] | + | * [[RDO_FETCH_LENGTHS()|rdo_fetch_lengths()]] - |
− | * [[RDO_FETCH_OBJECT()|rdo_fetch_object()]] | + | * [[RDO_FETCH_OBJECT()|rdo_fetch_object()]] - |
− | * [[RDO_FETCH_ROW()|rdo_fetch_row()]] | + | * [[RDO_FETCH_ROW()|rdo_fetch_row()]] - |
− | * [[RDO_FIELD_FLAGS()|rdo_field_flags()]] | + | * [[RDO_FIELD_FLAGS()|rdo_field_flags()]] - |
− | * [[RDO_FIELD_LEN()|rdo_field_len()]] | + | * [[RDO_FIELD_LEN()|rdo_field_len()]] - |
− | * [[RDO_FIELD_NAME()|rdo_field_name()]] | + | * [[RDO_FIELD_NAME()|rdo_field_name()]] - |
− | * [[RDO_FIELD_SEEK()|rdo_field_seek()]] | + | * [[RDO_FIELD_SEEK()|rdo_field_seek()]] - |
− | * [[RDO_FIELD_TABLE()|rdo_field_table()]] | + | * [[RDO_FIELD_TABLE()|rdo_field_table()]] - |
− | * [[RDO_FIELD_TYPE()|rdo_field_type()]] | + | * [[RDO_FIELD_TYPE()|rdo_field_type()]] - |
− | * [[RDO_FREE_OBJECT()|rdo_free_object()]] | + | * [[RDO_FREE_OBJECT()|rdo_free_object()]] - |
− | * [[RDO_FREE_RESULT()|rdo_free_result()]] | + | * [[RDO_FREE_RESULT()|rdo_free_result()]] - |
− | * [[RDO_GET_CLIENT_INFO()|rdo_get_client_info()]] | + | * [[RDO_GET_CLIENT_INFO()|rdo_get_client_info()]] - |
− | * [[RDO_GET_HOST_INFO()|rdo_get_host_info()]] | + | * [[RDO_GET_HOST_INFO()|rdo_get_host_info()]] - |
− | * [[RDO_INFO()|rdo_info()]] | + | * [[RDO_INFO()|rdo_info()]] - |
− | * [[RDO_LIST_DBS()|rdo_list_dbs()]] | + | * [[RDO_LIST_DBS()|rdo_list_dbs()]] - |
− | * [[RDO_NUM_FIELDS()|rdo_num_fields()]] | + | * [[RDO_NUM_FIELDS()|rdo_num_fields()]] - |
− | * [[RDO_NUM_ROWS()|rdo_num_rows()]] | + | * [[RDO_NUM_ROWS()|rdo_num_rows()]] - |
− | * [[RDO_PING()|rdo_ping()]] | + | * [[RDO_PING()|rdo_ping()]] - |
− | * [[RDO_QUERY()|rdo_query()]] | + | * [[RDO_QUERY()|rdo_query()]] - |
− | * [[RDO_REAL_ESCAPE_STRING()|rdo_real_escape_string()]] | + | * [[RDO_REAL_ESCAPE_STRING()|rdo_real_escape_string()]] - |
− | * [[RDO_RESULT()|rdo_result()]] | + | * [[RDO_RESULT()|rdo_result()]] - |
− | * [[RDO_SELECT_DB()|rdo_select_db()]] | + | * [[RDO_SELECT_DB()|rdo_select_db()]] - |
− | * [[RDO_STAT()|rdo_stat()]] | + | * [[RDO_STAT()|rdo_stat()]] - |
− | * [[RDO_THREAD_ID()|rdo_thread_id()]] | + | * [[RDO_THREAD_ID()|rdo_thread_id()]] - |
− | * [[RDO_UNBUFFERED_QUERY()|rdo_unbuffered_query()]] | + | * [[RDO_UNBUFFERED_QUERY()|rdo_unbuffered_query()]] - |
===Using Recital Client/Server === | ===Using Recital Client/Server === |
Revision as of 10:05, 28 July 2010
Contents
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)
- rdo_affected_rows() - return the number of rows affected by the last operation
- rdo_close() -
- rdo_connect() -
- rdo_data_seek() -
- rdo_errno() -
- rdo_error() -
- rdo_exec() -
- rdo_fetch_array() -
- rdo_fetch_assoc() -
- 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() -