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