Home » Developer & Programmer » Forms » LOV validation (form 9i)
LOV validation [message #381833] Tue, 20 January 2009 01:18 Go to next message
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 ?
Re: LOV validation [message #381835 is a reply to message #381833] Tue, 20 January 2009 01:22 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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
Re: LOV validation [message #381839 is a reply to message #381835] Tue, 20 January 2009 01:30 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
I agree with Mr. Littlefoot.

Regards,
Azam Khan
Re: LOV validation [message #382337 is a reply to message #381833] Thu, 22 January 2009 00:06 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: LOV validation [message #384335 is a reply to message #381833] Tue, 03 February 2009 06:29 Go to previous message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
nice thoughts
Previous Topic: AVOIDING OF MESSAGES
Next Topic: Use of Webutil Library to export to Excel
Goto Forum:
  


Current Time: Sat Dec 03 06:02:30 CST 2016

Total time taken to generate the page: 0.10359 seconds