Re: HELP WITH POPULATE LIST IN DEVELOPER/2000

Hi,

create a record group with 2 character columns. (forms requires that both are character, use to_char if a column isn't a character column)

The first column is the visible column,
the value of the second column will be stored in the item.

1. Create a record group called EMPS

select ename, to_char(empno)
from emp

2. Create a list item (list item type poplist)

3. Write into your when-new-form-instance trigger declare

    v_dummy number;
begin

   v_dummy := POPULATE_GROUP ( 'EMPS' );   POPULATE_LIST ( '<blockname>.<item name>', 'EMPS' ); end;

That's all.

Patrick

On 31 Jul 1998 15:01:32 GMT, "kaT" <katiray_at_hotmail.com> wrote:

>Hi!!!
>
>Please a need help!!!!!
>
>I am a beginer in Developer/2000.
>How can I populate a combobox from a Record_Group ?
>I have tryed , but always I have the next error :
>
>"FRM-41334 Invalid Record Group for populate list"
>
>There are same way to populate a combobox whithout cursor ???
>
>Thanks.
>
>Ski
>
>PLEASE RESPOND TO GROUP

E-Mails: patrick.wolf_at_telekabel.at (home)

         wolf_at_scigames.at (work) Received on Sat Aug 01 1998 - 20:13:04 CEST