Ispirer Website Ispirer Capabilities - PowerBuilder Conversion Free Trial

PowerBuilder - Error Handling

In PowerBuilder, you can check whether a SQL statement is failed or not using SQLCode and SQLDBCode variables.

SQLCode

SQLCode contains one of the following return code after SQL statement execution:

  • 0 - Successful execution
  • -1 - The statement failed. Use SQLDBCode to obtain the details (see below)
  • 100 - No rows found

SQLDBCode

SQLDBCode contains the database vendor-supplied status code.

For example, for Informix database, SQLDBCode contains the value -239 if a row cannot be inserted due to duplicate value in unique index.


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.