Re: QUERY PROBLEM?

[Quoted] J. Yen wrote in message <357BCCFE.2F331A3D_at_comp.hkbu.edu.hk>...
>I used the below SQL statement, but only last record selected.
>DECLARE
> CURSOR C IS
> SELECT A.SEQNO
> ,A.NAME
> FROM NAME A
> WHERE A.DEPT = 'ACCT';
>
> BEGIN
> OPEN C;
> LOOP
> FETCH C INTO
> :SEQNO, :NAME;
> EXIT WHEN C%NOTFOUND;
> END LOOP;
> CLOSE C;
>
> END;
>
> Does anyone know the problem in this SQL statement? Thank you!
>

What are :SEQNO, :NAME . If these are the names of you Dev2K form items then you have to use :block.field notation. Received on Mon Jun 08 1998 - 15:02:15 CEST