error trapping in FORMS 5
From: wozi <wozi_at_dhc.net>
Date: Sun, 17 Oct 1999 12:55:03 -0700
Message-ID: <7BE44547B0C08A8B.9BEF5AD575570426.D7FA1A449D231D1C_at_lp.airnews.net>
When I issue execute_query using set_block_propert's default_where, I get FRM:40350 when no is found. However, when there is data, it works. I want to trap 40350 and replace it with my alert message.
declare
al_button number;
v_errr number := ERROR_CODE;
begin
if v_error = 40350 THEN
al_button = show_alert('myalert');
raise form_trigger_failure;
end if;
end;
Date: Sun, 17 Oct 1999 12:55:03 -0700
Message-ID: <7BE44547B0C08A8B.9BEF5AD575570426.D7FA1A449D231D1C_at_lp.airnews.net>
When I issue execute_query using set_block_propert's default_where, I get FRM:40350 when no is found. However, when there is data, it works. I want to trap 40350 and replace it with my alert message.
on-error trigger at theblock level
declare
al_button number;
v_errr number := ERROR_CODE;
begin
if v_error = 40350 THEN
al_button = show_alert('myalert');
raise form_trigger_failure;
end if;
end;
This does not work!
Any help would be appreciated Received on Sun Oct 17 1999 - 21:55:03 CEST