Home » Developer & Programmer » Forms » lov (form 6i windows xp)
lov [message #351661] Thu, 02 October 2008 03:40 Go to next message
hisham99
Messages: 86
Registered: October 2008
Location: united arab emirates
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
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: 10180
Registered: March 2005
Location: Canberra ACT 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: 86
Registered: October 2008
Location: united arab emirates
Member
can you please show me how ,i mean can you give me an example
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: 28
Registered: April 2008
Location: KARACHI
Junior 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
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: 86
Registered: October 2008
Location: united arab emirates
Member
thanks but can we have other solution than commit each record separately ,
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: 10180
Registered: March 2005
Location: Canberra ACT 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
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
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: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
With which part of "Look at 'add_list_element' and 'delete_list_element'." are you having a problem?

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


Current Time: Tue Dec 06 08:38:39 CST 2016

Total time taken to generate the page: 0.08399 seconds