I think that your problem is that you do not change the record.
FETCH LOOPTEST INTO :MCDS_CCCO.PN, :NSN, :NOUN;
Your loop ALWAYS fetches a record to same fields :MCDS_CCCO.PN, :NSN, :NOUN
in first record. So in the final in those fileds you have last record of
your query.
Try to do NEXT_RECORD after fetch instruction.
U¿ytkownik "D.D." <d.delisser_at_worldnet.att.net> napisa³ w wiadomo¶ci
news:dm2N4.21265$PV.1504819_at_bgtnsc06-news.ops.worldnet.att.net...
> I have two blocks on a form and each block is a separate table. I want to
> be able to leave a field called "EI_SN" and populate the multi-record
block
> with values from another table. I used the following cursor. I retrieves
the
> last record only. The following is the cursor I used. I tried next_record
> and it doesn't work either.
>
> Please help!!!! - Urgent!
>
> DECLARE
> CURSOR LOOPTEST IS
> SELECT PN, NSN, NOUN FROM MCDS_TEST1 WHERE EI_SN = :MCDS_TEST2.EI_SN;
> BEGIN
> OPEN LOOPTEST;
> LOOP
> FETCH LOOPTEST INTO :MCDS_CCCO.PN, :NSN, :NOUN;
> EXIT WHEN LOOPTEST %NOTFOUND;
> END LOOP;
> CLOSE LOOPTEST;
> END;
>
> Thanks.... I have tried everything!!!!
> Jean
>
>
Received on Tue Apr 25 2000 - 00:00:00 CDT
