Re: forms4.x: display multi-record block

In <42gngs$ahv_at_cougar.vut.edu.au> leng_at_cougar.vut.edu.au (Leng Kaing) writes:
>
>Hello :-
>I'm attempting to write a trigger to display multiple records on the
>one block when someone presses the query button - similar to what the
>Query | Execute menu item achieves. I've written a pl/sql block but
>the records fetched keeps getting displayed on the first row of the
>block. As such I can only see the last record of the database.
>Please show me how to see them all at the same time, in separate rows.
>
>Here's my code:
>
>declare
> CURSOR dept_cur is
> select deptno, dname, loc from dept;
>begin
> for dept_rec in dept_cur loop
> :deptno := dept_rec.deptno;
> :dname := dept_rec.dname;
> :loc := dept_rec.loc;
> next_item;
> end loop;
>end;
>

  The records fetched keeps getting displayed on the first row becuase   inside the loop you have to include

             NEXT_RECORD;
  which will take you to next record.

  Hope this helps

  Swapan Jha
  Consultant - Oracle
  USA    Received on Tue Sep 05 1995 - 00:00:00 CEST