CREATE_GROUP_FROM_QUERY
From: Mark Liston <m.a.liston_at_man2701.wins.icl.co.uk>
Date: Wed, 1 Jul 1998 17:26:56 +0100
Message-ID: <359a635a.0_at_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
Date: Wed, 1 Jul 1998 17:26:56 +0100
Message-ID: <359a635a.0_at_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
Received on Wed Jul 01 1998 - 18:26:56 CEST