Appendix:appendix
Appendix appendix Specific constants for Database Engines

Specific constants for Database Engines Foundation

This section contains tables listing specific constants to set or get information about the configuration of single Database Engines. They are defined in the files ???DBE.CH.

Constants for DbeInfo() with the DBFDBE
Constant *) Value Data type Description
DBFDBE_MEMOFILE_EXT ro DBT C Extension for memo file
DBFDBE_MEMOBLOCKSIZE ro 512 N Block size for memo fields
DBFDBE_LOCKOFFSET a 2*10^9 N Offset for record locks
DBFDBE_LOCKMODE a DBF_NOLOCK N Mode for record locks
DBFDBE_LOCKRETRY a 3 N Maximum number of new
lock attempts with RLock()
DBFDBE_LOCKDELAY a 25 N Time interval for new
lock attempts with RLock()
(Unit is 1/100 seconds)
  1. ro=READONLY , a=ASSIGNABLE

Constants for a DBF database-object
Constant *) Data type Description
DBFDBO_DBFHANDLE ro N File handle of DBF file
DBFDBO_DBTHANDLE ro N File handle of DBT file
DBFDBO_LOCKMODE ro N Mode for record locks
DBFDBO_LOCKOFFSET ro N Offset for record locks
DBFDBO_LOCKDELAY a N Time interval between
lock attempts
DBFDBO_LOCKRETRY a N Number of lock attempts
  1. ro=READONLY , a=ASSIGNABLE

Constants for DbeInfo() with the FOXDBE
Constant *) Value Data type Description
FOXDBE_MEMOFILE_EXT a FPT C Extension for memo file
FOXDBE_MEMOBLOCKSIZE a 64 N Block size for memo fields
FOXDBE_LOCKOFFSET a 2*10^9 N Offset for record locks
FOXDBE_LOCKRETRY a 3 N Maximum number of new
lock attempts with RLock()
FOXDBE_LOCKDELAY a 25 N Time interval for new
lock attempts with RLock()
(Unit is 1/100 seconds)
  1. ro=READONLY , a=ASSIGNABLE

Constants for DbInfo() with the FOXDBE
Constant *) Value Data type Description
FOXDBO_MEMOBLOCKSIZE ro 64 N Block size for memo fields
FOXDBO_LOCKOFFSET ro 2*10^9 N Offset for record locks
FOXDBO_LOCKRETRY ro 3 N Number of lock attempts
FOXDBO_LOCKDELAY ro 25 N Time interval between
lock attempts (unit: 1/100 second)
  1. ro=READONLY , a=ASSIGNABLE

Constants for the SDFDBE (System Data Format)
Constant *) Value Data type Description
SDFDBE_STRUCTURE_EXT a SDF C Extension for the
structure file
SDFDBE_DECIMAL_TOKEN a . C Character for decimal point
SDFDBE_LOGICAL_TOKEN a TF C Character for logical values
SDFDBE_AUTOCREATION a .F. L TXT file is automatically
created by DbCreate()
  1. ro=READONLY , a=ASSIGNABLE

Constants for the DELDBE (Delimited format)
Constant *) Value Data type Description
DELDBE_MODE a #define N Operation mode
DELDBE_RECORD_TOKEN a CR+LF C Separation character
for record
DELDBE_FIELD_TOKEN a , C Separation character
for fields
DELDBE_FIELD_TYPES a "" C String describing data
types for fields
DELDBE_DELIMITER_TOKEN a " C Embedding character
for character values
DELDBE_DECIMAL_TOKEN a . C Character for
decimal point
DELDBE_LOGICAL_TOKEN a TF C Characters for logical
values
DELDBE_MAX_BUFFERSIZE a 64 N Max. size for record
in KB
  1. ro=READONLY , a=ASSIGNABLE

Constants for the operating mode of the DELDBE (Delimited format)
Constant Description
DELDBE_AUTOFIELD *) Multiple fields per record. The first
record does not contain field names.
Field names are FIELD1, FIELD2 up to FIELDn
DELDBE_MULTIFIELD Multiple fields per record. The first
record contains field names.
DELDBE_SINGLEFIELD One field per record. Field delimiters
are ignored. The field name is FIELD.
  1. default mode

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.