Im trying to write some sql script (not inside a procedure or trigger) to
modify some data in my tables using variables to temporarily store data and
use it a little further on in the script. This is an example of what i have
at the moment:

declare variable MaxValue integer;

which from what i have read of the documentation is correct syntax but when
i run it I get the following error:

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 9
variable
Statement: declare variable MaxValue int

Im using firebird 1.02 under windows

Regards
Martin

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/03


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