DBError – PB Docs 2019

Description

Triggered when an error occurs during a transaction or an attempted
transaction.

Event ID

Arguments

Return Values

Long, but this return code has no meaning to PowerBuilder.

Usage

Error codes

For any database related error, the error code comes from the
database driver. The error text is also from the database drivers. The
sqlsyntax argument shows what SQL syntax was executing when the error
occurred.

For errors that are not related to database drivers, the code
argument is set to -4. If the PowerBuilder VM cannot get the syntax for
these types of errors, an empty string is passed to the sqlsyntax
argument. PowerBuilder cannot get the syntax for the following types of
errors:

The PowerBuilder VM can get the SQL syntax for the following types
of errors, and passes it to the Transaction object’s DBError event for the
following types of errors:

Use with embedded SQL

By default, whenever an error occurs in the Transaction object, the
DBError event is called. The error code and error message are passed to
this event. You can add code to the DBError event to handle these
errors.

Use with DataWindow/DataStore

When using a Transaction object with a DataWindow, the DataWindow
DBError event is triggered before the DBError event of the Transaction
object. The return value for the DataWindow DBError event is used to
indicate whether the Transaction object’s DBError event should be
triggered in turn. When the return value of the DataWindow DBError event
is 0 or 1, the Transaction object’s DBError event is also triggered if it
is defined. When the return value of the DataWindow DBError event is 2 or
3, the Transaction object’s DBError event is ignored.

Examples

The following code in the DBError event displays the error message
and the SQL statement sent to the DBMS when a transaction error
occurs:

See also

DBError in the section called “DBError” in DataWindow Reference

SQLPreview