FRM-41042: Cannot create Group REC - Error [message #366346] |
Fri, 12 December 2008 22:29 |
akrish
Messages: 2 Registered: December 2008
|
Junior Member |
|
|
Hi,
Based on radio-button option, I am populating 2 tables records into list item thru create_query in On-Mouse-Click of Radio-group button trigger.
Example.
If rdbtn1, then populate emp data to list item,
if rdbtn2, then populate dept data to list item
Again if I select rdbtn1, then it showing "FRM-41042: Cannot create Group REC" - Error. Please assist me. Advance thanks.
Here is my code..
DECLARE
REC RECORDGROUP;
REC1 RECORDGROUP;
STATUS NUMBER;
BEGIN
if :cntrl.RADIO_GROUP17 = 10 then
clear_list('list5');
REC :=CREATE_GROUP_FROM_QUERY('REC','select to_char(empno),ename from emp1');
IF NOT ID_NULL(REC ) THEN
STATUS:=POPULATE_GROUP(REC);
POPULATE_LIST('list5',REC);
END IF;
else
clear_list('list5');
REC1 :=CREATE_GROUP_FROM_QUERY('REC1','select to_char(dept_id),dept_name from dept1');
IF NOT ID_NULL(REC1 ) THEN
STATUS:=POPULATE_GROUP(REC1);
POPULATE_LIST('list5',REC1);
END IF;
end if;
END;
[Updated on: Sat, 13 December 2008 01:33] Report message to a moderator
|
|
|
Re: FRM-41042: Cannot create Group REC - Error [message #375754 is a reply to message #366346] |
Sun, 14 December 2008 02:31 |
tarekfathi2003
Messages: 23 Registered: August 2008 Location: kw
|
Junior Member |
|
|
I think your code should be like this
DECLARE
rec recordgroup;
rec1 recordgroup;
status NUMBER;
BEGIN
IF :cntrl.radio_group17 = 10 THEN
CLEAR_LIST ('list5');
rec := FIND_GROUP ('REC');
IF NOT ID_NULL (rec) THEN
DELETE_GROUP ('REC');
END IF;
rec := CREATE_GROUP_FROM_QUERY ('REC','select to_char(empno),ename from emp1');
status := POPULATE_GROUP (rec);
POPULATE_LIST ('list5', rec);
ELSE
CLEAR_LIST ('list5');
rec1 := FIND_GROUP ('REC1');
IF NOT ID_NULL (rec1) THEN
DELETE_GROUP ('REC1');
END IF;
rec1 := CREATE_GROUP_FROM_QUERY('REC1', 'select to_char(dept_id),dept_name from dept1' );
status := POPULATE_GROUP (rec1);
POPULATE_LIST ('list5', rec1);
END IF;
END;
|
|
|
|