OraFAQ Forum: Forms » LOV validation

Home » Developer & Programmer » Forms » LOV validation (form 9i)

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

LOV validation [message #381833]

Tue, 20 January 2009 01:18

laith
Messages: 41
Registered: December 2008
Location: U.A.E

Member

i have form has database block, this block has fields ,one of them is active indicator (Y,N) I wrote code in the active indicator suppose when i chose (N) nothing i can change in the other fields, but one of field (address ) has LOV, when i click this field... the lov show and when i chose on of the row from lov, it comes to the field and i don't want this lov show anything in the feild when active indicator is (N) BUT should this LOV working normaly when active indicator is (Y).
which code i have to write in the trigger for field (address) has LOV?
Can you help me with this issue ?

Report message to a moderator

Re: LOV validation [message #381835 is a reply to message #381833]

Tue, 20 January 2009 01:22

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

Senior Member
Account Moderator

LoV is displayed executing the KEY-LISTVAL trigger. By default, it displays the list of values. If you want to implement additional logic, write it into this trigger code, such as

if certain_condition = 'Y' then
   show list of values
else
   do nothing
end if

Report message to a moderator

Re: LOV validation [message #381839 is a reply to message #381835]

Tue, 20 January 2009 01:30

azamkhan
Messages: 557
Registered: August 2005

Senior Member

I agree with Mr. Littlefoot.

Regards,
Azam Khan

Report message to a moderator

Re: LOV validation [message #382337 is a reply to message #381833]

Thu, 22 January 2009 00:06

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In the 'when-new-record-instance' trigger at the block level, you could also set the 'LOV_name' property to 'null'.

David

Report message to a moderator

Re: LOV validation [message #384335 is a reply to message #381833]

Tue, 03 February 2009 06:29

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

nice thoughts

Report message to a moderator

Previous Topic:	AVOIDING OF MESSAGES
Next Topic:	Use of Webutil Library to export to Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 10 09:21:30 CDT 2026