Error Reporting
When a report is run, any errors that occur are written to the trace window. Optionally, some errors may be displayed in popup windows. When run without popups (default) the report is non-interactive, allowing it to be run in batch mode.
In the Setup/Cleanup frame you can add error checking for the SQLcode that you provide. Curprocedure.dbsession.errornumber can be used to detect errors, and the Reporter-defined variable errtxt can be used to provide the error description:
inquire_sql(errtxt = errortext);
Reports return the following values:
-1
Error
0
No rows
>0
Rowcount or OK
Last modified date: 06/25/2024