Re: How do you load a list item programmatically??

Richard Hollingsworth wrote:
>
> Hi:
>
> Oracle 8i, Forms 6.
>
> How do you load a list item from the DB table programmatically? I have
> Lulushi's book for Forms, but he does it differently. He says you have
> to 'hard-code' at least one value in the list, then execute...
>
> :GLOBAL.original_item := :block.field:
>
> in a "When-New-Item-Instance" trigger to do this.
>
> Problem is, that only loads the 'hard-coded' value into the list when
> you run the form. I need to load ALL the choices "from the table" into
> the list.
>
> Can't you do this with a 'select distinct...' SQL statement from the
> trigger?
>
> If you know how to do this, please email me the steps.
>
> Thanks much,
> Richard Hollingsworth

1. create a record group with "create_group_from_query"
2. call populate_list using the record group

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy