Home » Developer & Programmer » Forms » lov (form 6i windows xp)
lov [message #351661] Thu, 02 October 2008 03:40 Go to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
i have a tabular form ,I Need to known When the List of Value (LOV) on Forms has been used, After the Selection of one Document if it possible to not view the selected document in next row (record) befor saving the form .

Eg: (LOV Contain)

Documentno
52060001
52060002
52060003
52060004


I Selected the Documentno has 52060003. After the selection I select another documentno for the continus of the Entry. They were List of Value Display Follows like.
Documentno
52060001
52060002
52060004

Report message to a moderator

Re: lov [message #351753 is a reply to message #351661] Thu, 02 October 2008 19:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I suggest doing a 'commit_form' when you have finished processing a record and in the 'record_group' used by the LOV you then modify the 'where' clause to exclude any 'Documentno' numbers that have been used.

David

Upd: Typo again. Change 'form_commit' to 'commit_form'.

[Updated on: Mon, 06 October 2008 22:17]

Report message to a moderator

Re: lov [message #351962 is a reply to message #351753] Fri, 03 October 2008 23:55 Go to previous messageGo to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
can you please show me how ,i mean can you give me an example

Report message to a moderator

Re: lov [message #351974 is a reply to message #351962] Sat, 04 October 2008 01:59 Go to previous messageGo to next message
anasjamil
Messages: 31
Registered: April 2008
Location: Sydney
Member
you can use commit at each record and insert the document name
in some other field (through some trigger on-commit etc)and can obtain the lov through modifying your
record group (can use a sub-query) in record group.



regards,
anas jamil

Report message to a moderator

Re: lov [message #352010 is a reply to message #351974] Sat, 04 October 2008 23:56 Go to previous messageGo to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
thanks but can we have other solution than commit each record separately ,

Report message to a moderator

Re: lov [message #352268 is a reply to message #352010] Mon, 06 October 2008 22:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Look at 'add_list_element' and 'delete_list_element'.

Remember that this will only work in a single user system.

David

Report message to a moderator

DELETE THE ELEMENT FROM THE LIST [message #386968 is a reply to message #352268] Tue, 17 February 2009 07:28 Go to previous messageGo to next message
Khan_4u
Messages: 5
Registered: February 2009
Location: UK
Junior Member
How can v delete the element at run time from the list

Report message to a moderator

Re: DELETE THE ELEMENT FROM THE LIST [message #387120 is a reply to message #386968] Wed, 18 February 2009 00:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
With which part of "Look at 'add_list_element' and 'delete_list_element'." are you having a problem?

David

Report message to a moderator

Previous Topic: Alignment Problem
Next Topic: How To Install Reports Run time in Reports 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 15 06:06:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.