Concept Framework 2.0 documentation Contents | Index

standard.db.sql.ODBCExecuteQuery

Name Version Deprecated
ODBCExecuteQuery version 1.0 no

Prototype:
number ODBCExecuteQuery(string query[, number connectionID])

Parameters:
query      the SQL query
connectionID      the ID identifying the connection as returned by ODBCDriverConnect or ODBCConnect. If this parameter is missing, this will affect the first connection created.

Description:
Create and executes a statement. The SQL query must not contain any bound parameters in order to successfully execute the query. For bounded parameters you must use the ODBCExecute function.

Also, after a query that provides results is successfully executed, you must call {ODBCBind} in order to be able to access the data in the result set (result set is the same as statement handle).

Returns:
Return handle of a statement containing the result of the executed query.

Documented by Eduard Suica, generation time: Fri Jan 21 18:06:22 2011 GMT(c)2011 RadGs Software