[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Update Process Monitor Status to 'Error'

The easiest way to change the process monitor to 'error' when your SQR fails, is
to use the ON-ERROR=sql-error in each select/sql statement.  Of course, you have
to include the prcsapi.sqc to get this error handling routine.  Note, that if
there is a compiler/sql/syntax error in the SQR, you can't trap the error and
the process monitor will always show 'initated'.

- Bob