OraFAQ Forum: Forms » Validation Control / Checks.

Home » Developer & Programmer » Forms » Validation Control / Checks.

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

Validation Control / Checks. [message #121965]

Thu, 02 June 2005 01:37

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I tabular form with three fields.

Total_Stock--------Stock_Issued---------Issue_Now

“Total_Stock” & “Stock_Issued” takes values from database. User just have to pass the value of “Issued_Now”.

I want to restrict the user to enter the value of “Issued_Now” ‘equal to’ or ‘less then’ (“Total_Stock”- “Stock_Issued”).

Wishes
Jawad

Report message to a moderator

Re: Validation Control / Checks. [message #121981 is a reply to message #121965]

Thu, 02 June 2005 04:30

A Ikramur Rahman
Messages: 81
Registered: May 2004

Member

Write a WHEN-VALIDATE-ITEM Trigger on the item "Issue_Now"

IF :Issue_Now > :Total_Stock - :Stock_Issued THEN
MESSAGE('Your message');
MESSAGE(' ',NO_ACKNOWLEDGE);
RAISE FORM_TRIGGER_FAILURE;
END IF;

Report message to a moderator

Re: Validation Control / Checks. [message #121997 is a reply to message #121965]

Thu, 02 June 2005 05:36

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear A Ikramur Rahman

Thank you very much.
it worked well.

Wishes
Jawad

Report message to a moderator

Previous Topic:	Forms 9i form size im IE
Next Topic:	Logon

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 21:31:59 CDT 2024