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.