i dont need to return a dataset, i need a CURSOR.
does FireBird syntax differs from Interbase classic?

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

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