showing query result in tabular form: missing results [message #78694] |
Mon, 11 March 2002 05:34 |
Xavier
Messages: 11 Registered: March 2002
|
Junior Member |
|
|
I have this query:
declare
cursor c1 is
select empno, empname, empsal
from emp;
begin
go_block('emp');
open c1;
loop
if :system.record_status !='NEW' then
create_record;
end if;
fetch c1 into :empno, :empname, :empsal;
exit when c1%notfound;
end loop;
first_record;
end;
What I want to do is display the 5 first results, then when I click on the 'next' button display the 5 next results, and so on till I displayed all results.
the problem is, this script shows the 5 first results, but when I click 'next' it shows then the 5 LAST results.
What can I do to display the results between?
Thx a lot if you can help me
|
|
|
|
|
|