Xref: alice comp.databases.oracle.tools:14215
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed1.swip.net!swipnet!rill.news.pipex.net!pipex!nntp.news.xara.net!xara.net!news.itg.net.uk!usenet
From: "Chris Hughes" <cahughes@globalnet.co.uk>
Newsgroups: comp.databases.oracle.tools
Subject: Re: CREATE_GROUP_FROM_QUERY
Date: Tue, 7 Jul 1998 15:15:32 +0100
Lines: 45
Message-ID: <6nts5u$hq4$3@heliodor.xara.net>
References: <359a635a.0@145.227.194.253>
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi Mark,

To use a record group as the basis for a List Item, it must have two group
columns specified.  Since your query only defines one column, this record
group cannot be used as the basis for a List Item.

Good luck,

Chris

Mark Liston wrote in message <359a635a.0@145.227.194.253>...
Hi,
I'm having problems running D2K Forms 4.5 on NT4. I have two procedures, one
of
which is selected to populate a List item, dependent on a radio button
selection. Both procedures are identical, except for the SELECT statement
used. The following procedure works:
BEGIN
sched_group_id := FIND_GROUP('fexd32_sched_group');
IF ID_NULL (sched_group_id)
THEN
  sched_group_id := CREATE_GROUP_FROM_QUERY ('fexd32_sched_group',
   'SELECT DISTINCT name, name FROM financial_institutions f,
scheduled_returns s
    where s.fi_identifier = f.identifier');
END IF;
query_ok := POPULATE_GROUP (sched_group_id);
IF query_ok != 0
THEN
  MESSAGE ('Unable to produce list of Financial Institutions');
END IF;
list_id := FIND_ITEM ('FEXD32_INSTITUTION');
POPULATE_LIST (list_id, sched_group_id);
END;
but using the following SELECT statement for the second procedure it fails:
SELECT DISTINCT name FROM financial_institutions
The error is FRM-41334: Invalid record group for list population. BTW, I am
using a different record group name in the second procedure.
Any help would be very gratefully received! Thanks,
Mark