OraFAQ Forum: Forms » problem in creating and populate a list with a record group

Home » Developer & Programmer » Forms » problem in creating and populate a list with a record group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in creating and populate a list with a record group [message #80900]

Thu, 12 December 2002 13:09

Archana
Messages: 18
Registered: January 2001

Junior Member

I am trying to create a record group at runtime and populate a list with this record group. When i try to run the form, I am getting a error FRM-41335 and sometimes FRM-41334 invalid column type for column 1.

Query i am writing in When-New-Form-Instance is

declare
rg_name varchar2(40) :='dept_rec';
status number;
rgroup recordgroup;
Begin
rgroup := create_group_from_query (rgname,'select
deptno,deptno from dept');
status:=populate_group(rgroup);
clear_list('deptno');
populate_list('deptno',rgroup);
end;

Please let me know what the problem is.

Report message to a moderator

Re: problem in creating and populate a list with a record group [message #80921 is a reply to message #80900]

Sat, 14 December 2002 07:38

Piyush Balan
Messages: 26
Registered: December 2002

Junior Member

Hi Archana,
it is a common problem faced in D2k. there's no great change required in the code. simply use to_char() function on the deptno column. run the form and it will definitely work.
i.e. instead of
rgroup := create_group_from_query (rgname,'select
deptno,deptno from dept');

write
rgroup := create_group_from_query (rgname,'select
to_char(deptno) deptno,to_char(deptno) deptno from dept');

let me know the results after this.

regards,
Piyush Balan,
Consultant,
Comsoft Pte. Ltd.,
Singapore

Report message to a moderator