Home » Developer & Programmer » Forms » failure of on-error trigger
failure of on-error trigger [message #375711] Mon, 11 December 2000 09:49
AJAY.K
Messages: 2
Registered: December 2000
Junior Member
I am working with forms 6 and even if try to trap error
number frm-40301 from on-error on form level for query retrived no records in enter_query mode nothing is happening.I would be very thankful if some one can tell me what's wrong.this is my code unit

DECLARE
errnum NUMBER := ERROR_CODE;
alert_button number;
BEGIN
IF :System.Mode = 'ENTER-QUERY' AND errnum = 40301 THEN
Set_Alert_Property('alert1', ALERT_MESSAGE_TEXT, 'Query returned no records');
alert_button := show_alert('alert1');
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;

Thanking you

Ajay.k
Previous Topic: Installing Developer 6.0
Next Topic: how to pass parameter with run_product
Goto Forum:
  


Current Time: Fri Mar 29 09:05:24 CDT 2024