Re: CREATE_GROUP_FROM_QUERY

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_at_nclient1-gui.server.virgin.net>,   "Ken Brown" <ken.brown_at_dialwrap.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 16:34:19 CET