OraFAQ Forum: Forms » LOV VALIDATION

Home » Developer & Programmer » Forms » LOV VALIDATION

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

LOV VALIDATION [message #175014]

Wed, 31 May 2006 07:16

rakas22
Messages: 29
Registered: May 2006

Junior Member

hi all
pls tell me how to check the value entered in text item is same as the values available in lov's record group. the record group iam using is static. otherwise it shoul return error message

please help me. urgent.
thanks

Report message to a moderator

Re: LOV VALIDATION [message #175021 is a reply to message #175014]

Wed, 31 May 2006 07:46

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

For example you create record group name ExRg with one column name DNO.

Declare
v_Alt Number;
rg_id RecordGroup;
v_DNo Varchar2(70);
v_RowCount Number;
BEGIN

rg_ID := find_Group('EXRG');
if ID_NULL(rg_ID) then
message('Invalid Group');
raise form_trigger_failure;
end if;

v_RowCount := Get_Group_Row_Count(rg_Id);

for a in 1 .. v_Rowcount loop

v_DNo := Get_Group_Char_Cell('EXRG.DNO',a);
if upper(v_DNo) = upper(:YoursITEM) then
return;
end if;
End Loop;
message(('Invalid value');
raise form_trigger_failure;
End;

hope it will help you. if you need further assistane please reply or mail me at mirza_rehan@yahoo.com

Best regards
R E H A N M I R Z A

Report message to a moderator

Re: LOV VALIDATION [message #175154 is a reply to message #175014]

Thu, 01 June 2006 01:57

gacki
Messages: 33
Registered: May 2006
Location: Dueren, NRW, Germany

Member

Set the item's "List of Value" property to your LOV and set the "Validate from List" property to yes.

Gerald

Report message to a moderator

Previous Topic:	Which products do I have to downloads free from oracle.com?
Next Topic:	calander in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:25:39 CDT 2024