Standard DAM Statement Methods

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.

Method Description
$clear $clear() Clear pending results or operations
$columns $columns(cTableName) Generates a result set describing the columns of the specified table
$execdirect $execdirect([cSQLtext]) One time execution of SQL text or current SQL buffer
$execute $execute() Execute SQL text or current SQL buffer
$fetch $fetch([lListOrRow] [,iRowCount] [,bAppend]) Fetch data into list or row
$fetchinto $fetchinto(...) Fetch a row of data into the supplied variables, one column of result data per variable
$fetchtofile $fetchtofile(cFileName [,iRowCount] [,bAppend] [,bColumnNames] [,iEncoding]) Fetch data into an external file. iEncoding is a kUniType... constant
$indexes $indexes(cTableName [,iIndexType=kStatementIndexUnique]) Generates a result set providing information about the indexes of a specified table
$nextnativeerror $nextnativeerror() Retrieve next native statement error
$prepare $prepare([cSQLtext]) Prepare SQL text or current SQL buffer
$results $results(lListOrRow) Populates pList with a description of the columns in the current result set
$rpc $rpc(cRpcName[,vRpcParam1,...]) calls a remote procedure
$rpcparameters $rpcparameters(cRpcName) Generates a result set listing the parameters of the specified remote procedure(s)
$rpcprocedures $rpcprocedures([cRpcOwner]) Generates a result set listing the available remote procedures
$tables $tables([iTableType=kStatementServerAll] [,cTableOwner]) Generates a result set listing the available tables