Identifier: dberr

Type

numeric

Description

The external database error status flag. When an error occurs during communication with an external database, e.g. on failure of an SQL command within a db or dbtrans command language block, dberr is set to 1.

When set to non-zero within a db/dbtrans command block (it can also be set by manual language assignment), all subsequent commands within the block are skipped, thereby acting as a "block abort".

It is reset to 0 automatically at the beginning of a db or dbtrans command. At the end of a dbtrans command block, the value of dberr determines whether a commit or rollback is to be performed on the database transaction. Therefore, setting its value manually can force a rollback.

dberr is also set to 1 by the failure of a dbstructure object to communicate properly with its parent external database.

When dberr gets set by a database operation, the .sqlcode element of the relevant database identifier can be used to access the internal number of the error.

See Also