Re: Forms 3.0 On-Message trigger

In article <1992Jun30.125309.11738_at_rz.uni-karlsruhe.de> rz34_at_rz.uni-karlsruhe.de writes:
>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.
>
>Thanks in advance!!
>
>Karen Schillinger

Problem quickly and easily solved!

Thanks to all who replied (couldn't get reply through to Michael Rife).              

Karen Schillinger Received on Wed Jul 01 1992 - 09:56:11 CEST