At 16:52 09/03/2004 +0000, you wrote:

>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.
>

Hi,

The syntax are not correct...

try this

set term ^;

create procedure sp_test returns(aName varchar(80)) as
begin
for select RDB$Relation_Name from rdb$Relations into :aName do begin
suspend;
end
end^

set term ;^

select * from sp_test



See you !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.596 / Virus Database: 379 - Release Date: 26/02/2004


[Non-text portions of this message have been removed]