At 12:34 AM 17/12/2011, patrick_marten wrote:

>Removing the semicolon ';' from the end of the statement did the trick! It's working now - with a Prepare prior to ParamByName and without it.
>
>But it's different after jason's change, since the very same statement was working before.
>
>Is it in general a bad idea to put a semicolon at the end of a statement?

Yes, it's a bad idea, as it is not valid SQL. The isql tool (and its scripts) need statement terminators and, by default, the semi-colon is "it". But it doesn't belong in DSQL statements in other environments.

Helen