OraFAQ Forum: Forms » oracle forms 9i

Home » Developer & Programmer » Forms » oracle forms 9i (9i)

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

oracle forms 9i [message #486340]

Wed, 15 December 2010 00:42

hketh786
Messages: 6
Registered: December 2010
Location: India

Junior Member

Hi i m using a field named order number and want it not to be left empty. which trigger should i use. i used when validate item and
use this
------------------------------------------
IF :order_no=NULL THEN
MESSAGE('HI');
RAISE FORM_TRIGGER_FAILURE;
END IF;
-----------------------------------------
but this is not working please help me..

Report message to a moderator

Re: oracle forms 9i [message #486342 is a reply to message #486340]

Wed, 15 December 2010 01:03

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Please try this.

IF :Order_no Is Null then 
Message('Order No Must Be Entered');
Message('Order No Must Be Entered');

Raise Form_Trigger_Failure;
End If;

Regards,
Irfan

Report message to a moderator

Re: oracle forms 9i [message #486345 is a reply to message #486342]

Wed, 15 December 2010 01:29

hketh786
Messages: 6
Registered: December 2010
Location: India

Junior Member

THANKS .. ITS WORKING

Report message to a moderator

Re: oracle forms 9i [message #486348 is a reply to message #486345]

Wed, 15 December 2010 01:33

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Thanks for the feedback.
Regards,
Irfan

Report message to a moderator

Re: oracle forms 9i [message #486350 is a reply to message #486348]

Wed, 15 December 2010 01:38

hketh786
Messages: 6
Registered: December 2010
Location: India

Junior Member

are you ONLINE..

Report message to a moderator

Re: oracle forms 9i [message #486351 is a reply to message #486350]

Wed, 15 December 2010 01:41

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Report message to a moderator

Previous Topic:	How to save image in oracle 9i and display the image on forms 6i
Next Topic:	FORMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:47:44 CDT 2024