OraFAQ Forum: Forms » Error Checking an Item in Forms 6.0

Home » Developer & Programmer » Forms » Error Checking an Item in Forms 6.0

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error Checking an Item in Forms 6.0 [message #79761]

Tue, 09 July 2002 10:18

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?

Report message to a moderator