|
|
| Re: creating record group from record group [message #87356 is a reply to message #87354] |
Wed, 22 December 2004 02:22   |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
Hello,
Try a WHEN-NEW-FORM-INSTANCE or a WHEN-NEW-BLOCK-INSTANCE Trigger with:
DECLARE
---------LIST -------------
group_id RecordGroup;
list_id Item := Find_Item('CONTROL.THELIST');
status NUMBER;
rg_name varchar2(40) := 'recgroup';
BEGIN
----------------------------- LIST
clear_list(list_id);
group_id := Find_Group(rg_name);
IF NOT id_null(group_id) then
Delete_Group(group_id);
End if;
group_id := Create_Group_From_Query(rg_name,
'SELECT TO_CHAR(EMPNO) ,TO_CHAR(EMPNO) FROM EMP');
status := Populate_Group(rg_name);
Populate_List(list_id, group_id);
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
