|Subject||Re: [firebird-support] Stored Procedure: variable does not want to be reset to NULL|
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.
Ok, so what's the speed of dark?