Hello Helen,

> >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
>

That's good and important to know, thank you!

Best regards,
Patrick