OraFAQ Forum: Forms » LOV Related Problem

Home » Developer & Programmer » Forms » LOV Related Problem

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

LOV Related Problem [message #149477]

Fri, 02 December 2005 00:12

rajeshsingh
Messages: 3
Registered: December 2005

Junior Member

I want to display only those field in LOV which is not selected previously.

Example: Suppose there are 4 row in DEPT table
10
20
30
40

First time when I press F9 total field content must display.
but in the next time it should display one less content.

How I do it?Please guide me. It is urgent.

Report message to a moderator

Fri, 02 December 2005 01:30

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can reference block items in your record group I think. Although I cannot verify this right now, you should test whether you can create your record group with a query like:

SELECT deptno
     , dname
  FROM dept
 WHERE deptno != :block.item

Again, I cannot verify this so it might be impossible this way. Another option would be to rebuild the record group each time you call the LOV.

MHE

Report message to a moderator

Tue, 06 December 2005 02:12

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

Senior Member
Account Moderator

Yes --- use your own record_group and remove an entry when it is used by a record. This problem has been raised in the last week or so, search this forum for 'create_record_group', there is also an 'add entry' and 'delete entry' command that I can't bring to mind right at this moment.

David

[Updated on: Tue, 06 December 2005 02:12]

Report message to a moderator

Previous Topic:	Problem with JPEG file
Next Topic:	Conversion of oracle form3 to forms6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:28:16 CDT 2024