ODBC Commands
From CometWiki
(Difference between revisions)
| (2 intermediate revisions not shown) | |||
| Line 7: | Line 7: | ||
'''Database''' | '''Database''' | ||
| - | dbBeginTrans | + | dbBeginTrans |
| - | dbCancel | + | dbCancel |
| - | dbCanTransact | + | dbCanTransact |
| - | dbCanUpdate | + | dbCanUpdate |
| - | dbClose | + | dbClose |
| - | dbCommitTrans | + | dbCommitTrans |
| - | dbDefineRecordset | + | dbDefineRecordset |
| - | dbDestroyRecordset | + | dbDestroyRecordset |
| - | dbExecuteSQL | + | dbExecuteSQL |
| - | dbGetBookmarkPersistence | + | dbGetBookmarkPersistence |
| - | dbGetConnect | + | dbGetConnect |
| - | dbGetCursorCommitBehavior | + | dbGetCursorCommitBehavior |
| - | dbGetCursorRollbackBehavior | + | dbGetCursorRollbackBehavior |
| - | dbGetDatabaseName | + | dbGetDatabaseName |
| - | dbGetLastError | + | dbGetLastError |
| - | dbIsOpen | + | dbIsOpen |
| - | dbOpen | + | dbOpen |
| - | dbRollback | + | dbRollback |
| - | dbSelectRecordset | + | dbSelectRecordset |
| - | dbSetLoginTimeout | + | dbSetLoginTimeout |
| - | dbSetOptions | + | dbSetOptions |
| - | + | "OpenExclusive" | |
| - | + | "OpenReadOnly" | |
| - | + | "UseCursorLib" | |
| - | + | "NoODBCDialog" | |
| - | + | "ForceODBCDialog" | |
| - | + | "ErrorCodes" | |
| - | dbSetQueryTimeout | + | dbSetQueryTimeout |
'''Recordset''' | '''Recordset''' | ||
| - | rsAddNew | + | rsAddNew |
| - | rsCanAppend | + | rsCanAppend |
| - | rsCanBookmark | + | rsCanBookmark |
| - | rsCancel | + | rsCancel |
| - | rsCancelUpdate | + | rsCancelUpdate |
| - | rsCanRestart | + | rsCanRestart |
| - | rsCanScroll | + | rsCanScroll |
| - | rsCanTransact | + | rsCanTransact |
| - | rsCanUpdate | + | rsCanUpdate |
| - | rsCheck | + | rsCheck |
| - | rsClose | + | rsClose |
| - | rsDelete | + | rsDelete |
| - | rsEdit | + | rsEdit |
| - | rsFlushResultSet | + | rsFlushResultSet |
| - | rsGetBookmark | + | rsGetBookmark |
| - | rsGetFieldValue | + | rsGetFieldValue |
| - | rsGetODBCFieldCount | + | rsGetODBCFieldCount |
| - | rsGetODBCFieldInfo | + | rsGetODBCFieldInfo |
| - | rsGetRecordCount | + | rsGetRecordCount |
| - | rsGetSQL | + | rsGetSQL |
| - | rsGetStatus | + | rsGetStatus |
| - | rsGetTableName | + | rsGetTableName |
| - | rsIsBOF | + | rsIsBOF |
| - | rsIsDeleted | + | rsIsDeleted |
| - | rsIsEOF | + | rsIsEOF |
| - | rsIsOpen | + | rsIsOpen |
| - | rsMove | + | rsMove |
| - | + | " FetchRelative" | |
| - | + | " FetchNext" | |
| - | + | " FetchPrior" | |
| - | + | " Fetch First" | |
| - | + | " FetchLast" | |
| - | + | " FetchAbsolute" | |
| - | + | " FetchBookmark" | |
| - | rsMoveFirst | + | rsMoveFirst |
| - | rsMoveLast | + | rsMoveLast |
| - | rsMoveNext | + | rsMoveNext |
| - | rsMovePrev | + | rsMovePrev |
| - | rsOpen | + | rsOpen |
| - | rsRequery | + | rsRequery |
| - | rsSetAbsolutePosition | + | rsSetAbsolutePosition |
| - | rsSetBookmark | + | rsSetBookmark |
| - | rsSetDefaultFilter | + | rsSetDefaultFilter |
| - | rsSetDefaultSort | + | rsSetDefaultSort |
| - | rsSetDefaultSQL | + | rsSetDefaultSQL |
| - | rsSetLockingMode | + | rsSetLockingMode |
| - | rsSetOpenOptions | + | rsSetOpenOptions |
| - | + | "None" | |
| - | + | "AppendOnly" | |
| - | + | "ReadOnly" | |
| - | + | "SkipDeletedRecords" | |
| - | + | "UseBookmarks" | |
| - | + | "DynaSet" | |
| - | "Snapshot" | + | "Snapshot" |
| - | "Dynamic" | + | "Dynamic" |
| - | "ForwardOnly" | + | "ForwardOnly" |
| - | rsUpdate | + | rsUpdate |
Latest revision as of 09:48, 29 May 2009
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
