OraFAQ Forum: Forms » check on lov filteration in oracle form

Home » Developer & Programmer » Forms » check on lov filteration in oracle form

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

check on lov filteration in oracle form [message #588182]

Sat, 22 June 2013 10:47

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

please resolve it.
i have field date_from date_to and Item_desc on form...
now i want when any item is inserted between these date it is romoved from lov list..
like
------------------------------------------------------------
date_from date_to Item
01-06-2013 05-06-2013 item_0001

next time when i insert the from date as

02-06-2013 04-06-2013 lov should not shown the item_0001 in list becuase the from date lies between the first record ....
this is ok when i commit the record in database and then shown the lov but if any user enter two or three record in data block befor the commit then the real problem to romove the item from litst.????
4 hours ago• Delete

Report message to a moderator

Re: check on lov filteration in oracle form [message #588184 is a reply to message #588182]

Sat, 22 June 2013 14:39

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

So use the post command in when-new-record-instance to write each record to the db as it is entered.

Report message to a moderator

Re: check on lov filteration in oracle form [message #588185 is a reply to message #588184]

Sun, 23 June 2013 00:15

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

post...
but what you suggest about the temprary table...

Report message to a moderator

Re: check on lov filteration in oracle form [message #588195 is a reply to message #588185]

Sun, 23 June 2013 03:16

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

what temporary table?

Report message to a moderator

Re: check on lov filteration in oracle form [message #588212 is a reply to message #588195]

Sun, 23 June 2013 14:53

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

Senior Member
Account Moderator

Suggestion is not to use it.

Report message to a moderator

Previous Topic:	when radio chenged trigger problem [merged 2 by jd]
Next Topic:	cannot attach library and FRM-10102: Cannot attach PL/SQL library (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 03:30:47 CDT 2024