Xbase++ database function support overview Professional
This section lists database related Xbase++ functions and their degree of support by the ODBC DatabaseEngine.
Legend:
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() | * |
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.