Home » Developer & Programmer » Forms » Error Checking an Item in Forms 6.0
Error Checking an Item in Forms 6.0 [message #79761] Tue, 09 July 2002 10:18 Go to next message
Jeff
Messages: 63
Registered: July 1999
Member
I have a trigger and procedure on an item called end date that validates date ranges and looks like this:

item:
BEGIN
Check_Date_Range(:jms_cs_ldi_rate.Start_Date,:jms_cs_ldi_rate.End_Date);
END;

procedure:
PROCEDURE Check_Date_Range ( d1 DATE, d2 DATE ) IS
BEGIN
IF d1 > d2 THEN
Message('Your date range ends before it starts!');
RAISE Form_Trigger_Failure;
END IF;
Message('Valid Date!');
END;

What do I add to make it so the user can not advance past this item until the date is valid?
Re: Error Checking an Item in Forms 6.0 [message #79765 is a reply to message #79761] Tue, 09 July 2002 21:03 Go to previous messageGo to next message
Subhash
Messages: 105
Registered: October 2001
Senior Member
Call this procedure in the 'When-Validate-Item' trigger of the Item.
Re: Error Checking an Item in Forms 6.0 [message #79824 is a reply to message #79761] Tue, 16 July 2002 23:14 Go to previous message
Shahid Nadeem
Messages: 8
Registered: July 2002
Junior Member
Write this code in the when-validate-item trigger of the item and handle the for-trigger-failure exception.
Previous Topic: executing programs from Forms and capture the output
Next Topic: Pentium 4
Goto Forum:
  


Current Time: Thu Mar 28 15:46:43 CDT 2024