Microsoft KB Archive/70860

PRSQL9103040: RAISERROR in Trigger Will Not Call Error Handler ID Number: Q70860

1.10 | 1.10 MS-DOS | OS/2 buglist1.10 fixlist1.16

Summary:

PROBLEM ID: PRSQL9103040

SYMPTOMS If a trigger exists that calls RAISERROR, under certain circumstances the statement that fires that trigger will not call the DB-LIBRARY (dblib) error handler as it should. Only if that statement is the first statement in a command batch will the RAISERROR call the error handler. However, the message handler will always be called by RAISERROR, regardless of a statement’s position in the command batch.

CAUSE Only if INSERT, UPDATE, or DELETE is the first statement in the command batch will the error handler of that dblib application be called. This applies to all three kinds of triggers: insert, update, and delete.

STATUS Microsoft has confirmed this to be a problem in DB-LIBRARY version 1.10. This problem has been corrected in DB-LIBRARY version 1.16, which is available from Microsoft Product Support Services. For more information, please contact your primary support provider.