Hi Helen,

> It's wrong practice. The rule is: always use a colon on a variable when
> you use the variable in an SQL statement and never use one otherwise.

OK.

> What DB version are you using? It should be throwing an "Unknown field"
> exception when you don't reference variables properly...

I am using Firebird 1.5. But it is the same as in Firebird 1.0x: in
some cases, the use of the colon is not enforced. The code snippet
I posted worked well, even without the colons everyone told me to
integrate.


Christian