General discussion

  • Creator
  • #2175638

    ORACLE FORMS-pop list index retrieval


    by madan_bharatwaj ·

    I have the following problem with a poplist.
    a. Retrieve all the values and the list index(eg: 1,2,3) from the list item and store them in a pl/sql table.
    b. When a value is chosen from the list,I need to get the list index from the list for that chosen value, and use that to retrieve the value from pl/sql table.

    I am using retrieve_list to store the values and even the list index using a counter. But I am unable to figure out how to get the appropriate list index for the chosen list value.

    Note – The label and value are same. Hence I cant use label as a list index.

    Eg – for list item values ‘a1′,’b1′,’b2′,’c3′ , I want to store them in table as (1,’a1′),(2,’b1′),(3,’b2’),(4,’c3). And when ‘b2’ is chosen , I want to get 3 from the list, and use that to retrieve the stored value in the table.

    I dont mind any other solution too where I can use numbers to store and retrieve values.


    Thanks in advance

All Comments

  • Author
    • #3331219

      Wrong forum

      by deepsand ·

      In reply to ORACLE FORMS-pop list index retrieval

      This is a tech. problem, in search of a solution.

      It properly belongs in “Technical Q&A,” not in “Discussions.”

      Please re-post there.

      Thank you.

Viewing 0 reply threads