Subject Re: [firebird-support] Stored Procedure: variable does not want to be reset to NULL
Author Bambang P
Helen, Martijn and Dmitry,

On Thursday, September 22, 2005, 5:32:50 PM, Helen Borrie wrote:

> Correct. The second statement cannot return anything, so there is nothing
> there to alter either the value of the variable (i.e. no value) or its
> state (e.g. change it to null).

Thanks for the explanation. I understand now.

> It's worthwhile to use correct syntax when referring to variables
> (including input and output arguments). The generic rule is that, if you
> refer to a variable in an SQL statement, you prefix it with a colon.

Thanks for the suggestion. I always try to remember to mark the
variables with semicolon in SQL statement. But, sometimes I do forget,
mainly when writing quick small code.

Bambang P.

Ok, so what's the speed of dark?