How to populate combo box with values of a table column?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to populate combo box with values of a table column?

  1. #1
    Join Date
    Apr 2001
    Posts
    125

    Question

    Hi, I am working on create a combo box which show the list of values of a table column, do you know where to put the select query to populate the combo box?

    I know combo box is memoryless, how can I make the new value also appears in the list?

    Thanks

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    You can do a query to get the range of values and then do something like this:

    -- Set position values
    port_stposn := :model.model_port_st_posn;
    port_cap := :model.model_port_capacity;
    maxposn := port_cap + port_stposn - 1;

    -- Fill LOV with open positions
    item_id := Find_Item('ADD_BLOCK.ADD_POSITION');
    if NOT ID_Null(item_id) then
    CLEAR_LIST(item_id);
    -- Create list of all valid positions
    for i IN port_stposn..maxposn LOOP
    ADD_LIST_ELEMENT(item_id,list_index,to_char(i),to_char(i));
    list_index := list_index + 1;
    end loop;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width