Database Engines:odbc
Xbase++ database function support overview Professional
This section lists database related Xbase++ functions and their degree of support by the ODBC DatabaseEngine.
Legend:
* - function works
+ - the function call is ignored
% - supported but deprecated
? - might work depending on conditions of other workareas
- - calling this function will result in a runtime error
| Function | Supp. | Precondition,Remarks |
|---|---|---|
| Alias() | * | |
| Bof() | * | |
| DbAppend() | * | see DbAppend() |
| DbCargo() | * | |
| DbClearFilter() | * | |
| DbClearIndex() | * | ODBCSSN_INDEX_AUTOOPEN |
| DbClearRelation() | % | |
| DbClearScope() | * | |
| DbCloseAll() | * | |
| DbCloseArea() | * | |
| DbCommit() | * | don not confuse with Transactions, see |
| DbCommitAll() | * | DacSession():beginTransaction() |
| DbContinue() | * | |
| DbCopyExtStruct() | * | |
| DbCopyStruct() | * | |
| DbCreate() | * | see Data Type Mapping |
| DbCreateExtStruct() | - | |
| DbCreateFrom() | * | |
| DbCreateIndex() | % | ODBCDBO_CREATE_INDEX |
| DbDelete() | * | ODBCDBO_DELETED_NAME |
| DbDescend() | * | |
| DbEdit() | % | ODBC_SCROLLABLE, see DbAppend() |
| DbeInfo() | * | |
| DbEval() | * | |
| DbExport() | ? | same datasource, data type mapping is different |
| between most datasources | ||
| Dbf() | * | |
| DbFilter() | * | |
| DbGoBottom() | * | |
| DbGoPosition() | * | |
| DbGoto() | * | |
| DbGoTop() | * | |
| DbImport() | ? | see DbExport() |
| DbInfo() | * | |
| DbJoin() | ? | see DbExport() |
| DbList() | * | |
| DbLocate() | * | |
| DbLocked() | + | returns .F. |
| DbPack() | */- | ODBCDBO_DELETED_NAME, error for SQL-commands |
| DbPosition() | * | |
| DbRecall() | * | ODBCDBO_DELETED_NAME |
| DbRefresh() | * | |
| DbReindex() | + | is a secret of the datasource |
| DbRelation() | + | |
| DbRList() | * | |
| DbRlock() | */+ | ODBC_CONCUR_LOCK typically supported |
| by file-based drivers only | ||
| DbRLockList() | * | |
| DbRRollback() | * | see DbAppend() for usage |
| DbScope() | * | |
| DbSeek() | * | ODBCSSN_INDEX_AUTOOPEN |
| DbSelectArea() | * | |
| DbSetDescend() | % | |
| DbSetFilter() | * | ODBC_SCROLLABLE, filter is executed on client |
| DbSetFound() | * | |
| DbSetIndex() | - | |
| DbSetOrder() | * | ODBCSSN_INDEX_AUTOOPEN |
| DbSetRelation() | ? | |
| DbSetScope() | * | |
| DbSkip() | * | |
| DbSkip(0) | * | refreshes current row if possible |
| DbSkip(-x) | * | ODBC_SCROLLABLE |
| DbSkipper() | % | XbpQuickBrowse() is recommended |
| DbSort() | + | |
| DbStruct() | * | see Data Type Mapping |
| DbTotal() | - | |
| DbUnlock() | * | |
| DbUnlockAll() | * | |
| DbUpdate() | - | |
| DbUseArea() | * | |
| DbZap() | */- | runtime-error for SQL-commands |
| Deleted() | * | ODBCDBO_DELETED_NAME |
| Eof() | * | |
| FCount() | * | |
| FieldBlock() | * | |
| FieldGet() | * | |
| FieldName() | * | |
| FieldPos() | * | |
| Flock() | + | record locks will be unlocked |
| Found() | * | ODBCSSN_INDEX_AUTOOPEN |
| IndexExt() | - | |
| IndexKey() | * | ODBCSSN_INDEX_AUTOOPEN |
| IndexOrd() | * | ODBCSSN_INDEX_AUTOOPEN, returns 1 |
| LastRec() | % | |
| LUpdate() | + | returns empty date |
| OrdBagExt() | - | |
| OrdBagName() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdCondSet() | % | |
| OrdCount() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdCreate() | % | ODBCDBO_CREATE_INDEX |
| OrdDestroy() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdFor() | % | |
| OrdIsDescend() | * | |
| OrdIsUnique() | * | |
| OrdKey() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdKeyNo() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdList() | * | ODBCSSN_INDEX_AUTOOPEN |
| OrdListAdd() | - | |
| OrdListClear() | - | |
| OrdListRebuild() | + | must be done by server |
| OrdName() | * | |
| OrdNumber() | * | |
| OrdSetFocus() | * | |
| RecCount() | * | |
| RecNo() | * | valid in current result set only |
| Rlock() | */+ | ODBC_CONCUR_LOCK, typically supported |
| by file-based drivers only | ||
| RecSize() | + | returns 0 |
| Select() | * | |
| Used() | * |
Feedback
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.