CREATE_GROUP_FROM_QUERY

From: Ken Brown <ken.brown_at_dialwrap.com>
Date: Mon, 1 Mar 1999 22:41:43 -0000
Message-ID: <7bf589$qsk$1_at_nclient1-gui.server.virgin.net>



[Quoted] I've create a WHEN-LIST-ACTIVATED trigger with

DECLARE
group_id RecordGroup;
list_id ITEM := Find_Item('<item>') error_status NUMBER;
BEGIN
group_id :- Create_Group_From_Query('GetTables', 'SELECT ps_sys_table_name_alias, ps_sys_table_name FROM ps_system_table_names');
error_status := Populate_Group(group_id); IF error_status <> 0 THEN
Raise_Form_Exception;
END IF;
Populate_List(list_id,group_id);

All I get back is a 41072 Cannot create group - this happened even if I use CREATE_GROUP('GetTables').

Using Oracle 8.0.5 and Forms 4.5 and 5.0 - logged on as owner.

Any idea's Received on Mon Mar 01 1999 - 23:41:43 CET

Original text of this message