Re: Forms 3.0 On-Message trigger

In article <1992Jun30.125309.11738_at_rz.uni-karlsruhe.de>, rz34_at_hp850.rz.uni-karlsruhe.de (Schillinger) 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.
>

I think that the following syntax would help you:

        else message(message_text);

I hope this helps. I didn't try it myself.

> 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 Wed Jul 01 1992 - 08:12:12 CEST