The properties listed here are standard properties of DAM statement objects. DAM statements which have a standard property only include the property name in their property table - please use the entry here to read about the property.
| $batchsize | The number of rows to retrieve simultaneously- enables batch fetching. Some databases do not support batch fetching in which case the value reverts to 1 |
| $columncount | The number of columns in the current result set (read-only) |
| $columndelimiter | The character which delimits column values when using $fetchtofile |
| $errorcode | The Omnis error code generated by last statement command (read-only) kDAMFileOpenFailed kDAMFileReadFailed kDAMInternalError kDAMInvalidFileName kDAMInvalidIndexType kDAMInvalidMapType kDAMInvalidTableType kDAMInvalidTranMode kDAMNativeErrorFailed kDAMNoClientLibrary kDAMNoError kDAMNoPendingError kDAMNotSerialised kDAMNotUnicode kDAMParameterError kDAMParameterNumError kDAMParameterTypeError kDAMServerMethodFailed kDAMServerPropertyFailed kDAMSqlError kDAMUnknownError kDAMWrongOmnisVersion kSessionBeginFailed kSessionBindMarkerFailed kSessionClearFailed kSessionColTextFailed kSessionCommitFailed kSessionInvalidSQLSeparator kSessionLobChunkSizeOutOfRange kSessionLobThresholdOutOfRange kSessionLogoffFailed kSessionLogonFailed kSessionNewStatementFailed kSessionNoDriverManager kSessionNoMapTable kSessionNotLoggedOn kSessionNoTranSupport kSessionNotTranManual kSessionRegisterFailed kSessionRollbackFailed kSessionRpcDefineFailed kSessionRpcNotDefined kSessionSetCharMapFailed kSessionSetMapTableFailed kSessionSetTranModeFailed kSessionUsesAutoBegin kStatementBindInputVarFailed kStatementBindResultColFailed kStatementBufferAllocationFailed kStatementClearFailed kStatementCloseFailed kStatementDescribeFailed kStatementDropFailed kStatementExecDirectFailed kStatementExecuteFailed kStatementFetchFailed kStatementFetchMemoryExceeded kStatementHasNoSession kStatementInputVarFailed kStatementInsertRowFailed kStatementNoFetchList kStatementNoFilename kStatementNoResults kStatementNotPrepared kStatementPrepareFailed kStatementResultColFailed kStatementReturnedInfo kStatementRpcGetParamValuesError kStatementRpcPrepareParamsError kStatementSendInputVarFailed kStatementSendResultVarFailed kStatementServerColumnsFailed kStatementServerIndexesFailed kStatementServerResultsFailed kStatementServerRpcParametersFailed kStatementServerRpcProceduresFailed kStatementServerTablesFailed |
| $errortext | The Omnis error text generated by last statement command (read-only) |
| $maxbuffersize | Sets the maximum buffer size per column- used when batch fetching. If a $fetch() exceeds this value; $effectivebatchsize receives the value that was used |
| $nativeerrorcode | The DBMS-specific native error code generated by last statement command (read-only) |
| $nativeerrorpending | kTrue if further native errors are available for the statement (read-only) |
| $nativeerrortext | The DBMS-specific native error text generated by last statement command (read-only) |
| $resultspending | kTrue if a result set exists (read-only) |
| $rowcount | The number of rows in the current result set (read-only) |
| $rowdelimiter | The character which delimits row values when using $fetchtofile |
| $rowsaffected | Rows affected by last executed INSERT or UPDATE statement. Some databases do not support this property in which case the value will be -1 (read-only) |
| $rowsfetched | The number of rows retrieved by the last $fetch() (read-only) |
| $rpcreturnvalue | Receives the return value of the most recent call to a remote procedure (read-only) |
| $sqlstripspaces | If kTrue, trailing spaces stripped from any fetched character data |
| $sqltext | The currently assigned SQL text (read-only) |
| $state | The current state of statement object, one of the kStatementState... constants (read-only) kStatementStateClear kStatementStateExecDirect kStatementStateExecuted kStatementStateFetching kStatementStatePrepared |
| $statementname | Name of the statement object (read-only) |
| $usecursor | Setting $usecursor to kTrue enables the use of a cursor for this statement (if the database supports cursors). $transactionmode should also be kSessionTranManual |