ODBC Commands
From CometWiki
(Difference between revisions)
| Line 12: | Line 12: | ||
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" | "OpenExclusive" | ||
"OpenReadOnly" | "OpenReadOnly" | ||
| Line 34: | Line 34: | ||
"ForceODBCDialog" | "ForceODBCDialog" | ||
"ErrorCodes" | "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" | " FetchRelative" | ||
" FetchNext" | " FetchNext" | ||
| Line 73: | Line 73: | ||
" FetchAbsolute" | " FetchAbsolute" | ||
" FetchBookmark" | " 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" | "None" | ||
"AppendOnly" | "AppendOnly" | ||
| Line 92: | Line 92: | ||
"UseBookmarks" | "UseBookmarks" | ||
"DynaSet" | "DynaSet" | ||
| - | "Snapshot" | + | "Snapshot" |
| - | "Dynamic" | + | "Dynamic" |
| - | "ForwardOnly" | + | "ForwardOnly" |
| - | rsUpdate | + | rsUpdate |
Revision as of 09:43, 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
