Hi Rick,

> Looks like that's the case. The error dump is below. The table has a
> simple primary key and a varchar called FNAME.
>
> The update string generated by Creator is:
>
> UPDATE SIMPLENAME SET PKEY = ?, FNAME = ? WHERE ((? IS NULL AND PKEY
> IS NULL) OR PKEY = ?) AND ((? IS NULL AND FNAME IS NULL) OR FNAME = ?)

Firebird seems to have problems with "? IS NULL", I would say this is
correct, because it is not possible to guess the datatype for parameter from
that code. But I also assume that other databases have no problems with this
code. Bad. I have no idea how to solve the issue.

Try asking in Firebird-support, maybe they have an idea how to deal with
such SQL. But avoid mentioning "Java" there, since you will be almost for
sure redirected here :)

Roman