Help!!!!!!

From: plusign <plusign_at_hotmail.com>
Date: 1998/02/21
Message-ID: <6cleme$oop$1_at_bs33n.staffs.ac.uk>#1/1


I have a problem here

i created a form that will accept user input(in number). If user input 10, the system will display ONLY 10 record that fulfil the criteria.

the problem: the system only display only last record into my form (in tabular format) at first row.

my code:

declare
input number(4);

cursor c1 is
select emp_no from emp where sal > 4000;

begin

open c1;
input := :employee.total_input;

loop

fetch c1 into :employee.emp_no;
exit when input - 1 <= 0

end loop;

end;

could anybody help me??

thank you very much Received on Sat Feb 21 1998 - 00:00:00 CET

Original text of this message