Home » Developer & Programmer » Forms » LOV (oracle 10g)
LOV [message #510845] Wed, 08 June 2011 01:47 Go to next message
swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai
Member
Dear,

I am using LOV on some field to retrive data, but sometimes it does not retrive anything cause of unaviablity of date its fine but i want to put N/A in that field when such condition is occoruing please help me

Swapnil Pimple

Report message to a moderator

Re: LOV [message #510855 is a reply to message #510845] Wed, 08 June 2011 02:15 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In WHEN-VALIDATE-ITEM trigger:
if :that_item is null then
   :that_item := 'N/A';
end if;

Report message to a moderator

Re: LOV [message #510872 is a reply to message #510855] Wed, 08 June 2011 03:00 Go to previous message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
That'll stop you using validate from list though.

Report message to a moderator

Previous Topic: Delete Record to Table
Next Topic: ORA-00942: table or view does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 12 08:55:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.