POPULATE LIST

[Andrea Colzi]

I get the frm-41337 error on a populate_list command. The code I use is:

rg_id := Create_Group_FROM_QUERY( 'AA',
'select ID_NAG, DESC from mx_nag');
errcode := Populate_Group( rg_id );
POPULATE_LIST('nag_id_nag',rg_id);

Both the columns are varchar2 and the query works fine. What's wrong?
And the only way to fill a list item with db data is with a group created at
runtime?

andrea

[Steve Cosner]

Maybe it is the "DESC" column. That is a reserved word in an order-by
clause, so it may cause a problem. Try pressing Shift-F1 (or
pull-down Help --> Display Error) to see the actual database error
message.

Steve Cosner

In article <7o74e7$797$1...@fe1.cs.interbusiness.it>,

[Andrea Colzi]

[Andrea Colzi]

[owais...@my-deja.com]

In article <BPEp3.22$Sp....@nntp.csufresno.edu>,

ste...@zimmer.csufresno.edu (Steve Cosner) wrote:
> Maybe it is the "DESC" column. That is a reserved word in an order-by
> clause, so it may cause a problem. Try pressing Shift-F1 (or
> pull-down Help --> Display Error) to see the actual database error
> message.
>
> Steve Cosner
>
> In article <7o74e7$797$1...@fe1.cs.interbusiness.it>,
> Andrea Colzi <m...@multidatagroup.it> wrote:

> i had similar problems...and what i figured out, for the version of
developer i was using was that the second element had to be a numeric
field...in your case, DESC. i am not sure whether this is still a
limitation in newer versions of forms or not. but nevertheless, try this
thing out.
regards
Owais

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.