Subject | cant declare cursor in FB 1.5 |
---|---|
Author | d_dude_2003 |
Post date | 2004-03-09T16:52:38Z |
whats wrong with the following code:
REATE PROCEDURE UPDATEEMPLOYEESTATS
AS
DECLARE VARIABLE EmployeeID INTEGER;
DECLARE AA CURSOR FOR SELECT EMPLOYEEID FROM EMPLOYEES;
BEGIN
OPEN AA
FETCH AA INTO :EmployeeID
It says "token unknown - CURSOR"
DECLARE statement looks exactly like in all manuals.
Thanx.
REATE PROCEDURE UPDATEEMPLOYEESTATS
AS
DECLARE VARIABLE EmployeeID INTEGER;
DECLARE AA CURSOR FOR SELECT EMPLOYEEID FROM EMPLOYEES;
BEGIN
OPEN AA
FETCH AA INTO :EmployeeID
It says "token unknown - CURSOR"
DECLARE statement looks exactly like in all manuals.
Thanx.