I always use the syntax:

DECLARE VARIABLE [name] [type]

... to create a variable inside a stored procedure or a trigger. I
wasn't even aware the other syntax worked (if it is not just a typo),
but stick with the above syntax. Declare is used as a keyword in many
places (cursors, statements, udf functions, filters etc), so possibly
you are looking at something different.



--- In firebird-support@yahoogroups.com, "Dixon Epperson"
<dixonepperson@y...> wrote:

>
> when creating a stored procedure why is it that sometimes you write
>
> AS
> DECLARE VAR1 INTEGER;
> BEGIN
>
> and other times you write it
>
> AS
> DECLARE VARIABLE VAR1 INTEGER;
> BEGIN
>
> E. D. Epperson Jr