Re: populating a list item

Use Create_Group_From_Query( ) inside a PU. I have a template for filling poplists, I put it into a PU_Populate_Poplists:

• PopList Filling Template

   Rg_Id := Find_Group( 'g_something' );

   If Not Id_Null( Rg_Id )
   Then

      Delete_Group( Rg_Id );
   End If;

   Rg_Id := Create_Group_From_Query( 'g_something',

            'select whatever||' '||kra_ort, to_char( kra_nr ) ' ||
            'from table ' ||
            'order by 1' );

   List_Id := Find_Item( 'MyBlockname.MyItem' );    Clear_List( List_Id );
   Az := Populate_Group( Rg_Id );
   Populate_List( List_Id, Rg_Id );

Then I start PU_Populate_Poplists in When_New_Form_Instance.

hth, Jan

"drukqs" <invalid.drukqs_at_NOpandoraSPAM.belgie> schrieb im Newsbeitrag news:Xns936CD375367CCinvaliddrukqspandora_at_195.130.132.69...
> Hi
>
> I want to make a form where I can make orders. If I click a button ("Make
> new order") I must be able to fill in a few fields (quantity, name, ...).
> But I have to be able to choose the name of a customer from a list. So it
> has to be sort of a db list (I hope I am clear enough here). I was
thinking
> on a query like this:
> select name
> into :cust.list
> from customers;
> I put this in a trigger (when new block instance). But it says there must
> be ellements defined in the list. Where do I need to put my query? Or am I
> doing things completely wrong here?.
> Thx
Received on Wed Apr 30 2003 - 04:51:36 CDT