CREATE_GROUP_FROM_QUERY

[Ken Brown]

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

[ca...@nams.net]

If you don't yet understand the nature of this problem, you might consider
including the record group in the form design. If there is still an error at
design time, perhaps the feedback from Form Builder will be more
helpful/informative. If the error goes away, this could be helpful too in
tracking down the problem. Just a suggestion....

Cary

In article <7bf589$qsk$1...@nclient1-gui.server.virgin.net>,

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own