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>


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.edu
Received on Tue Mar 02 1993 - 16:01:10 CET

Original text of this message