Quieting a Forms 4.5 error msg

From: anthony <anthony_at_sisko.dnaco.net>
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 error message up?

				Thanks in advance.
				Anthony
Received on Mon Oct 02 1995 - 00:00:00 CET

Original text of this message