Help!!!!!!
From: plusign <plusign_at_hotmail.com>
Date: 1998/02/21
Message-ID: <6cleme$oop$1_at_bs33n.staffs.ac.uk>#1/1
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