Subject Re: [firebird-support] Firebird Variable Declaration Problem
Author Milan Babuskov
Uwe wrote:
> I have a very simple problem which I can't resolve.
>
> How do you declare a variable in Firebird WI-V2.50.26074 Firebird 2.5 on Windows 7 64bit ?
>
> I try the following statement in Flamerobin
>
>
> DECLARE variable myvar integer;

You need to wrap this into PSQL construct like stored procedure, trigger
or EXECUTE BLOCK.

set term !! ;

EXECUTE BLOCK AS
DECLARE VARIABLE mvvar INTEGER;
BEGIN
... do something
END !!

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================