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 -> Re: populating a list item

Re: populating a list item

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Tue, 29 Apr 2003 20:28:33 GMT
Message-ID: <RfBra.8171$Jf.4109235@news1.news.adelphia.net>


Look into using record groups and LOVs. The LOV can be triggered from your button with show_lov.

"drukqs" <invalid.drukqs_at_NOpandoraSPAM.belgie> wrote in message 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 Tue Apr 29 2003 - 15:28:33 CDT

Original text of this message

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