How do you load a list item programmatically??

Hi:

[Quoted] Oracle 8i, Forms 6.

[Quoted] How do you load a list item from the DB table programmatically? I have [Quoted] Lulushi's book for Forms, but he does it differently. He says you have [Quoted] 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.

[Quoted] 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 Received on Thu Nov 16 2000 - 23:24:10 CET