Re: Problems with cursor in forms 4.5

Srikanth Patibanda wrote:
> I got stucked in using cursors. Actually my problem is i got to
> retrieve more than one row from the database on to the forms 4.5 block.

If you really have to do it that way, you should navigate to NEXT_RECORD in your loop. But can't you make analyzed_samples1 the base table of that
block, set where condition and perform a regular query?

> open c1;
> loop
>
> fetch c1 into :analyzed_samples1.st_id,
> :analyzed_samples1.sample_date,
> :analyzed_samples1.time,
> :analyzed_samples1.compid,
> :analyzed_samples1.concentration;
> exit when c1%notfound;
> end loop;
>
> close c1;
> END;
>
> I really appreciate if anyone answer my question.
>
> Thanking you
>
> SRIKANTH.PATIBANDA
  Received on Fri Feb 07 1997 - 00:00:00 CET