Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

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.


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

sqlways/powerbuilder/error-handling.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement