DAM statement objects enable you to send SQL commands to the server and process results. The methods listed here are standard methods of DAM statement objects.
| $clear | $clear() Clears pending results or operations. Returns kTrue on success, kFalse otherwise |
| $columns | $columns(cTableName) Generates a result set describing the columns of the specified table. Returns kTrue on success, kFalse otherwise. Call $fetch() to retrieve the result set |
| $execdirect | $execdirect([cSQLtext]) One time execution of the specied SQL text. If omitted $execdirect() uses the current Begin/End statement SQL buffer. Returns kTrue on success, kFalse otherwise |
| $execute | $execute() Executes SQL text prepared previously usiung $prepare(). Returns kTrue on success, kFalse otherwise |
| $fetch | $fetch([lListOrRow][,iRowCount][,bAppend]) Fetches data into the supplied list or row. Returns a kFetch... constant, e.g. kFetchOk. See Catalog(F9)->Tables for other fetch states |
| $fetchinto | $fetchinto(...) Fetches a row of data into the supplied variables,one column of result data per variable. Returns a kFetch... constant, e.g. kFetchOk. See Catalog(F9)->Tables for other fetch states |
| $fetchtofile | $fetchtofile(cFileName[,iRowCount][,bAppend][,bColumnNames][,iEncoding]) Fetches data into an external file. iEncoding is a kUniType... constant. Returns a kFetch... constant, e.g. kFetchOk. See Catalog(F9)->Tables for other fetch states |
| $indexes | $indexes(cTableName[,iIndexType=kStatementIndexUnique]) Generates a result set providing information about the indexes of a specified table. Returns kTrue on success, kFalse otherwise. Call $fetch() to retrieve the result set |
| $nextnativeerror | $nextnativeerror() When $nativeerrorpending is kTrue, retrieves the next native statement error code & error text from the DBMS |
| $prepare | $prepare([cSQLtext]) Prepares the specified SQL text. If omitted $prepare() uses the current Begin/End statement SQL buffer. Returns kTrue on success, kFalse otherwise |
| $results | $results(lListOrRow) Populates the supplied with a description of the columns in the current result set. Returns kTrue on success, kFalse otherwise |
| $rpc | $rpc(cRpcName[,vRpcParam1,...]) calls a remote procedure. The procedure must be previously defined using $rpcdefine(). Returns kTrue on success, kFalse otherwise |
| $rpcparameters | $rpcparameters(cRpcName) Generates a result set listing the parameters of the specified remote procedure(s). Returns kTrue on success, kFalse otherwise. Call $fetch() to retrieve the result set |
| $rpcprocedures | $rpcprocedures([cRpcOwner]) Generates a result set listing the available remote procedures. Returns kTrue on success, kFalse otherwise. Call $fetch() to retrieve the result set |
| $tables | $tables([iTableType=kStatementServerAll][,cTableOwner]) Generates a result set listing the available tables. Returns kTrue on success, kFalse otherwise. Call $fetch() to retrieve the result set |