OraFAQ Forum: Forms » FRM-41334: Invalid record group for list population

Home » Developer & Programmer » Forms » FRM-41334: Invalid record group for list population

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

FRM-41334: Invalid record group for list population [message #464027]

Mon, 05 July 2010 23:03

jocylau
Messages: 11
Registered: July 2010

Junior Member

I created 3 radio buttons and one list item. Different options will appear according to the radio button the user has clicked on. i've created 3 recordgroups and 3 LOV. the first two for seven_eleven and mannings work fine, but not for GNC. is it because there is only one option for list item in GNC? Must it be more than one? I've tried to another option as space but it still doesnt work.

Please help me to solve the prob. Thanks!

DECLARE

it_id1 item;

V_SEVEN_ELEVEN RECORDGROUP:=NULL;
V_MANNINGS RECORDGROUP:=NULL;
V_GNC RECORDGROUP:=NULL;

BEGIN

it_id1 := find_item('B_DEV.LIST_ITEM');
V_SEVEN_ELEVEN :=FIND_GROUP ('V_SEVEN_ELEVEN');
V_MANNINGS :=FIND_GROUP ('V_MANNINGS');
V_GNC :=FIND_GROUP ('V_GNC');

IF (:B_DEV.FOR_BANNERS = 'SEVEN_ELEVEN') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_SEVEN_ELEVEN);

end if;

IF (:B_DEV.FOR_BANNERS = 'MANNINGS') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_MANNINGS);

end if;

IF (:B_DEV.FOR_BANNERS = 'GNC') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_GNC);

end if;

END;

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464032 is a reply to message #464027]

Mon, 05 July 2010 23:38

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

What are the values in the record groups?
V_SEVEN_ELEVEN
V_MANNINGS
V_GNC
Have they populated by any sql statement or static?

By
Vamsi

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464043 is a reply to message #464032]

Tue, 06 July 2010 00:42

jocylau
Messages: 11
Registered: July 2010

Junior Member

i have input static values into the record group
for V_SEVEN_ELEVEN: rmsehk, smsehk
for V_MANNINGS: vmmnhk,ommnhk,qmmnhk
for V_GNC: smghhk

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464656 is a reply to message #464043]

Thu, 08 July 2010 11:09

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

The Record Group should have two char columns. Check this.
What are all your Column Names and Column Values for those Record Groups?
V_SEVEN_ELEVEN
V_MANNINGS
V_GNC

Uploading a sample Static Record Group with two columns.
/forum/fa/7984/0/

/forum/fa/7984/0/

By
Vamsi

Attachment: Sample_Static_RG.JPG
(Size: 46.01KB, Downloaded 9745 times)

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464698 is a reply to message #464656]

Thu, 08 July 2010 20:36

jocylau
Messages: 11
Registered: July 2010

Junior Member

what if i only have one column as option in list item
can the other one be spacing(empty) instead?

Or are there other ways to solve this problem, please?

Thanks a lot!

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464702 is a reply to message #464027]

Thu, 08 July 2010 21:51

jocylau
Messages: 11
Registered: July 2010

Junior Member

the attachment is the fmb file
could you please check the LOV and recordgroups please?
Thanks

Attachment: template.fmb
(Size: 224.00KB, Downloaded 3037 times)

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464704 is a reply to message #464656]

Thu, 08 July 2010 22:09

jocylau
Messages: 11
Registered: July 2010

Junior Member

By the way... there should be only one option for GNC which is SMGHHK. thanks

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464705 is a reply to message #464704]

Thu, 08 July 2010 22:16

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

It is giving error while opening the fmb.
Anyway, I'm not talking about the number of values.
You need to concentrate on the number of columns for each Record Group.
Paste your Record Groups, as I did in the previous post.

By
Vamsi

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464706 is a reply to message #464705]

Thu, 08 July 2010 22:45

jocylau
Messages: 11
Registered: July 2010

Junior Member

No Message Body

Attachment: untitled.JPG
(Size: 45.34KB, Downloaded 2417 times)

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464707 is a reply to message #464706]

Thu, 08 July 2010 23:07

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

Anyway, I'm not talking about the number of values.
You need to concentrate on the number of columns for each Record Group.

Check my sample once again.
It doesn't bother about the number of values for each column name.
But you should have two column names.

In my sample I can have one value also.
NUMBER - 1
WORDS - ONE.
Here the LOV will be populated by 1 and ONE, NOT NUMBER and WORDS.
Those are just names of the columns.
So, I think your other Records Groups might also be wrongly defined. Crosscheck them once.

In a nutshell, for each of the record group, you need to have two column names, those can be anything like NAME, VALUE or whatever.
But the values vary.

For V_SEVEN_ELEVEN:
NAME - rmsehk, smsehk
VALUE - rmsehk, smsehk

For V_MANNINGS:
NAME - vmmnhk,ommnhk,qmmnhk
VALUE - vmmnhk,ommnhk,qmmnhk

For V_GNC:
NAME - smghhk
VALUE - smghhk

By
Vamsi

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464709 is a reply to message #464707]

Thu, 08 July 2010 23:32

jocylau
Messages: 11
Registered: July 2010

Junior Member

so what did I do wrong?
from my print screen
i did put the following for V_GNC:
NAME - smghhk
VALUE - smghhk

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464714 is a reply to message #464709]

Fri, 09 July 2010 00:27

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

You got me wrong.
Check this screen.
/forum/fa/7990/0/

/forum/fa/7990/0/

Try this (for all the three record groups) and let me know, whether it is working or not.

By
Vamsi

Attachment: record_group_change.JPG
(Size: 35.92KB, Downloaded 9292 times)

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464719 is a reply to message #464714]

Fri, 09 July 2010 01:13

jocylau
Messages: 11
Registered: July 2010

Junior Member

it works now. Thank you so much.

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #464721 is a reply to message #464719]

Fri, 09 July 2010 01:19

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Just wanted add one point.
The reason to have two sets of column "names" and "values" is: because LOV is having id and value.
Even though the set of values are same for id and value of LOV, you need to have two sets in record group.

By
Vamsi

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #677028 is a reply to message #464721]

Thu, 08 August 2019 03:40

Rehman_Mani
Messages: 1
Registered: August 2019

Junior Member

Hi my question is same related this problem i m create MAKE_LIST throug procedure in program unit butt form runtime eror is FRM 41334:

PROCEDURE MAKE_LIST IS

group_id RecordGroup;
group_name varchar2(10) := 'abc';
status number;
begin

group_id := find_group(group_name);
if not id_null(group_id) then
delete_group(group_id);
end if;
group_id := Create_Group_From_Query(group_name,'select lookup_det_name from PRL_lookup_det where lookup_id = ''116'' and active=''Y''');
status := Populate_group(group_id);
Populate_List('PRL_VEHICLE_DATA.MANUFEC_BY',group_id);
END;

Report message to a moderator

Re: FRM-41334: Invalid record group for list population [message #677047 is a reply to message #677028]

Mon, 12 August 2019 05:23

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

As mentioned earlier in the thread record groups for list items need two columns - one for the value displayed and one for the value stored.
Your record group query only selects one column.
If you want the same value displayed and stored then select it twice.

Report message to a moderator

Previous Topic:	Write Image from Forms6i to Client local system
Next Topic:	Runaway sessions cpu infinite loop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:37:45 CST 2024