Forms 3.0 On-Message trigger

I'm having some trouble with an ON-MESSAGE trigger on SQL*Forms 3.0.16.8.1.

All I wanted to do was to change the message FRM-40301 (and FRM-40350 which are actually the same) to something else. So I wrote the following on-message trigger:

if message_code=40301 or message_code=40350 then message('new message... blah blah'); end if;

When I did this I noticed that the new message worked wonderfully but I couldn't use "count query hits". On further observation, I realized I wasn't getting any messages EXCEPT the new message from my trigger.

Even when I added the line:

else raise form_trigger_failure;

it didn't help.

I WANT all those other messages -and- my new one. What am I missing or doing wrong?? It's such a simple task, isn't it?

Please reply via e-mail: rz34_at_hp850.rz.uni-karlsruhe.de

Thanks in advance!!

Karen Schillinger Received on Tue Jun 30 1992 - 14:53:09 CEST