ODBC Commands

From CometWiki

ODBC Commands

ODBC commands fall into two categories, Database commands and Recordset commands. The following lists show the commands that are implemented in the Comet ODBC Client Gateway. (For detailed information about these commands, refer to Microsoft’s ODBC and programming documentation.)

Database

dbBeginTrans dbCancel dbCanTransact dbCanUpdate dbClose dbCommitTrans dbDefineRecordset dbDestroyRecordset dbExecuteSQL dbGetBookmarkPersistence dbGetConnect dbGetCursorCommitBehavior dbGetCursorRollbackBehavior dbGetDatabaseName dbGetLastError dbIsOpen dbOpen dbRollback dbSelectRecordset dbSetLoginTimeout dbSetOptions "OpenExclusive" "OpenReadOnly" "UseCursorLib" "NoODBCDialog" "ForceODBCDialog" "ErrorCodes" dbSetQueryTimeout

Recordset

rsAddNew rsCanAppend rsCanBookmark rsCancel rsCancelUpdate rsCanRestart rsCanScroll rsCanTransact rsCanUpdate rsCheck rsClose rsDelete rsEdit rsFlushResultSet rsGetBookmark rsGetFieldValue rsGetODBCFieldCount rsGetODBCFieldInfo rsGetRecordCount rsGetSQL rsGetStatus rsGetTableName rsIsBOF rsIsDeleted rsIsEOF rsIsOpen rsMove " FetchRelative" " FetchNext" " FetchPrior" " Fetch First" " FetchLast" " FetchAbsolute" " FetchBookmark" rsMoveFirst rsMoveLast rsMoveNext rsMovePrev rsOpen rsRequery rsSetAbsolutePosition rsSetBookmark rsSetDefaultFilter rsSetDefaultSort rsSetDefaultSQL rsSetLockingMode rsSetOpenOptions "None" "AppendOnly" "ReadOnly" "SkipDeletedRecords" "UseBookmarks" "DynaSet" "Snapshot" "Dynamic" "ForwardOnly" rsUpdate