Skip to content

List of Error Tables

The list of error tables tree appears on the left side of the main window.

The tree displays all the possible error code tables. If you click on one of the entries, the tool tries to open the corresponding error table. If this action is successful, the data grid will be shown on the right-hand side with the records found in the error table. If the table could not be opened, you have the option to create the error table. Usually, you do not want to do this and should find out why the error table cannot be opened.

User errors are stored in the first file called FLEXERRS.DAT, and you may use the error numbers starting at 120. You can add a maximum of 3976 errors. Error numbers are assigned in sequential order; there cannot be a gap in the error numbers.

The format of the error tables must be in embedded database format. Converting to one of the supported database drivers results in an inability to open and display error information by the virtual machine.

Users can browse through the records and translate the description/note of the error. Records can only be added in the FLEXERRS.DAT file using error numbers from 120 through 4096. Error numbers below 120 or higher than 4096 cannot be deleted via the Maintenance program.

The Usr\Language folder contains a set of subdirectories with translated error tables. You can distribute these tables if the end-user wants to have an error in another language.

User

The User errors are stored in FLEXERRS.DAT and run from 120 to 4096. The first 120 error numbers are DataFlex errors present from history.

System

The System errors are stored in DFERR001.DAT and run from 4097 to 8192. These error numbers cover, among others, the DataFlex Server Edition and DBMS-API errors.

Utility

The Utility errors are stored in DFERR002.DAT and run from 8193 to 12287. These errors are used by the DataFlex utilities/tools.

DBMS Drivers

The DBMS driver errors are stored in DFERR003.DAT. The range of these errors starts at 12288 and ends at 16384. The ODBC driver errors are located in this file.

Pervasive.SQL

The Pervasive.SQL (Btrieve) Driver uses its own error file. The errors are stored in DFERR005.DAT and run from 20481 to 24568. Refer to the Pervasive.SQL Driver documentation for more information about this error range.

Reserved

The Reserved errors are stored in DFERR004, DFERR006, and DFERR007. These blocks of error numbers are reserved for the future.