SQL*Forms 3.0 multi-record block question
From: Ed Howe <ehowe_at_quip.eecs.umich.edu>
Date: Tue, 2 Mar 1993 15:01:10 GMT
Message-ID: <1993Mar2.150110.4948_at_zip.eecs.umich.edu>
Date: Tue, 2 Mar 1993 15:01:10 GMT
Message-ID: <1993Mar2.150110.4948_at_zip.eecs.umich.edu>
In SQL*Forms 3.0, how do I fill a multi-record block that is not part of a master-detail relationship? I've tried using
DECLARE
CURSOR my_cursor IS SELECT blah blah blah;
...
BEGIN
...
OPEN my_cursor;
...
LOOP
FETCH my_cursor INTO :block.field;
EXIT WHEN my_cursor%NOTFOUND;
END LOOP;
END;
where :block.field is a field in a multi-record block. This doesn't seem to
work. When I put a SYNCHRONIZE call in the LOOP, I see that each FETCHed
record overwrites the first row of the column (the first record in the multirecord
block) rather than filling the column.
Is there any way to accomplish what I'm trying to do? Any help would be greatly appreciated.
Thanks,
Ed Howe
-- ehowe_at_eecs.umich.eduReceived on Tue Mar 02 1993 - 16:01:10 CET