Home » Developer & Programmer » Forms » problem in creating and populate a list with a record group
problem in creating and populate a list with a record group [message #80900] Thu, 12 December 2002 13:09 Go to next message
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.
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 Go to previous messageGo to next message
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
Re: problem in creating and populate a list with a record group [message #80926 is a reply to message #80900] Sat, 14 December 2002 12:12 Go to previous messageGo to next message
Archana
Messages: 18
Registered: January 2001
Junior Member
I got it.

Thanks for your help

Archana
Re: problem in creating and populate a list with a record group [message #82379 is a reply to message #80921] Fri, 23 May 2003 01:42 Go to previous messageGo to next message
Kanagaraj
Messages: 7
Registered: May 2001
Junior Member
I too faced the same problem, which i found solution in this site.Thanks Piyush Balan.
Re: problem in creating and populate a list with a record group [message #206442 is a reply to message #80900] Thu, 30 November 2006 01:30 Go to previous messageGo to next message
mhatre.mandar
Messages: 1
Registered: April 2006
Location: Mumbai
Junior Member

thanx a lot
its of very helpful for less experience
programmmers
like us

keep the good work
Re: problem in creating and populate a list with a record group [message #283340 is a reply to message #80921] Mon, 26 November 2007 15:25 Go to previous message
shivaram9
Messages: 35
Registered: August 2006
Member
Thanks alot Piyush Balan.

I was getting the same error and to_char() solved my problem.

Shiva
Previous Topic: FRM 10256
Next Topic: Re: Free Book on Developer 2000
Goto Forum:
  


Current Time: Sat Dec 10 16:22:40 CST 2016

Total time taken to generate the page: 0.14189 seconds