Quieting a Forms 4.5 error msg
Date: 1995/10/02
Message-ID: <44pfqc$5b2_at_sisko.dnaco.net>#1/1
I am running Forms 4.5 and am performing a number of querries in a particular form. In this case, I have one parent block that the user performs a query on, then can use the up and down arrows to scroll though the database items one at a time. In the triggers for key-up and key-down, is:
next_item; (or previous item, for up arrow)
go_block('block2');
clear_block;
execute_query;
Block2 is a separate block that is a "child" of the first. For each row
of the parent, block2 is queried for a line that matches it in a
different table. Everything works great except when there is no matching
row to be found for block2. Then block2 comes up as empty, which is
fine, but it pops up the error message "FRM-40350: Query caused no
records to be retrieved." Once the error is cleared by clicking "OK",
everything is just fine.
The problem is that the error message is annoying and alarms the
users. I would like to have the form function in exactly the same way,
but not have the error messages appear.
I have tried the on-error trigger and the "exception" statement
in the PL/SQL, but have had no luck. Does anyone know how to shut this
Thanks in advance. AnthonyReceived on Mon Oct 02 1995 - 00:00:00 CET