OraFAQ Forum: Forms » when-validate-item

Home » Developer & Programmer » Forms » when-validate-item

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

when-validate-item [message #83445]

Wed, 08 October 2003 05:47

Mubeen
Messages: 44
Registered: February 2003

Member

hi all,

I am passing this code in when-validate-item trigger though the raise form_trigger_Failure is working but the message is not working.
can anybody help me out plz
thanx in advance.
mubeen

Declare
cnt number;

Begin

Select count into cnt from customer where cust_cd = :Bk_tcst.Cust_cd;

If :bk_tcst.cust_cd is Null Then
Message('Customer code cannot be Empty..');
Message(' ');
raise form_trigger_failure;
End if;

If cnt > 1 then
Message('Customer Already exists..');
Message(' ');
raise form_trigger_failure;
End if;

End;

Report message to a moderator

Re: when-validate-item [message #83446 is a reply to message #83445]

Wed, 08 October 2003 06:12

I.K
Messages: 2
Registered: October 2003

Junior Member

hi mubeen
u do one thing u raise the form_trigger_failure after end if....i hope it will work.......

Report message to a moderator

Re: when-validate-item [message #83447 is a reply to message #83446]

Wed, 08 October 2003 06:28

Mubeen
Messages: 44
Registered: February 2003

Member

hi i.k

Thanx for prompt reply but the problem is the alerts are not working.just if that works out then my problem is solved.

Thanx

mubeen

Report message to a moderator

Re: when-validate-item [message #83448 is a reply to message #83445]

Wed, 08 October 2003 08:53

I.K
Messages: 2
Registered: October 2003

Junior Member

Declare
cnt number;

Begin

Select count into cnt from emp where empno = :emp.empno;

If :emp.comm is Null Then
Message('Customer code cannot be Empty..');
Message(' ');
End if;
raise form_trigger_failure;

hi mubeen
i hav tried this code it works....i hope ur problem will be solved....
Declare
cnt number;

Begin

Select count into cnt from emp where empno = :emp.empno;

If :emp.comm is Null Then
Message('Customer code cannot be Empty..');
Message(' ');
End if;
raise form_trigger_failure;

Report message to a moderator

Re: when-validate-item [message #83454 is a reply to message #83447]

Fri, 10 October 2003 02:12

Arvind Bhandari
Messages: 50
Registered: May 2003

Member

please check console window property is defined or not in Form Level Property

Arvind

Report message to a moderator

Previous Topic:	Do you want to save the changes you have made?
Next Topic:	Calling Web Report from Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 06 16:07:44 CDT 2026