This discussion is archived
3 Replies Latest reply: Dec 21, 2012 11:11 AM by Andreas Weiden RSS

list values return items

newbi_egy Explorer
Currently Being Moderated
db and dev 10g rel2 , xp sp3
hi all,
i've a lot of text items , and i want to create a lov which return it's data into the text_item double-clicked .
i mean , when i
double-click t1 , lov appears , select a value , returns into t1 .
double-click t2 , lov appears , select a value , returns into t2 .
and so on

thanks in advance
  • 1. Re: list values return items
    vansul Pro
    Currently Being Moderated
    lov will have only one return item.
    you can manipulate that data by showing the lov on each t1 t2 t3 etc and use a trigger as wehn validate item on the return item which will be non visible. and will return you the data to desired t1 t2 etc.
  • 2. Re: list values return items
    newbi_egy Explorer
    Currently Being Moderated
    what code do you want me to write in the when-button-pressed trigger ,
    how can i return the value into another item ?


    another question please :
    if i created about 10 lovs , would that affect the performance negatively ?

    thanks
  • 3. Re: list values return items
    Andreas Weiden Guru
    Currently Being Moderated
    two ways:

    1. make the return item an item in your block that is not shown, then do a SHOW_LOV and after that copy the value from your invisible item into the desired item.

    2. make ten lovs on the same query each with a different return item.

    btw.. Havin ten lov's copying the same value into different items sounds a little like a bad datadesign. Is it the test-thing with having ten tests in one table? If so, you already see what complications this approach makes.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points