OraFAQ Forum: Forms » help in when validate item triggre please

Home » Developer & Programmer » Forms » help in when validate item triggre please

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

help in when validate item triggre please [message #402910]

Wed, 13 May 2009 01:18

trainee04
Messages: 1
Registered: May 2009

Junior Member

Good day,

Can any 1 help me in the syntax needed for the when-validate-item for a varchar type for oracle forms builder

the code i used is

if xx_dso_emp.fss_emp_id is number then
message ('please enter a text')

else

do_key ('commit form');
go_block('xx_dso_emp');
end if;
end;

Thank you in advance Cool

Report message to a moderator

Re: help in when validate item triggre please [message #402914 is a reply to message #402910]

Wed, 13 May 2009 01:55

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you want to accept a numeric value only, then don't use a character datatype item (as well as table column). Why would you want to code something that Oracle handles itself by default?

Report message to a moderator

Re: help in when validate item triggre please [message #402928 is a reply to message #402910]

Wed, 13 May 2009 04:06

colesmoke
Messages: 4
Registered: October 2008
Location: Chennai

Junior Member

Hi,

You cannot use COMMIT_FORM and GO_BLOCK in WHEN-VALIDATE-ITEM.

Thanks & Regards,
Satyam

Report message to a moderator

Previous Topic:	webutill not working in Locked Vista Machines
Next Topic:	1 LOV using in 4 items

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 24 05:41:30 CDT 2026