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.