Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> populating a list item

populating a list item

From: drukqs <invalid.drukqs_at_NOpandoraSPAM.belgie>
Date: Tue, 29 Apr 2003 18:42:23 GMT
Message-ID: <Xns936CD375367CCinvaliddrukqspandora@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 Tue Apr 29 2003 - 13:42:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US