Home » Developer & Programmer » Forms » help in when validate item triggre please
icon3.gif  help in when validate item triggre please [message #402910] Wed, 13 May 2009 01:18 Go to next message
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
Re: help in when validate item triggre please [message #402914 is a reply to message #402910] Wed, 13 May 2009 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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?
Re: help in when validate item triggre please [message #402928 is a reply to message #402910] Wed, 13 May 2009 04:06 Go to previous message
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
Previous Topic: webutill not working in Locked Vista Machines
Next Topic: 1 LOV using in 4 items
Goto Forum:
  


Current Time: Fri Dec 02 21:04:12 CST 2016

Total time taken to generate the page: 0.12392 seconds