Hi,

I'm trying to create the Prepared Statement below with "? IS NULL" in
it. This generates an error in Firebird 1.5.2 SS.

Is there a workaround for this, or is this going to be fixed anytime
soon? MySQL, Postgres, Oracle, etc., etc. support this syntax, so it
creates a signifucant incompatibility if you are trying to migrate to
Firebird.

The statement is:

UPDATE SIMPLENAME SET PKEY = ?, FNAME = ? WHERE ((? IS NULL AND PKEY
IS NULL) OR PKEY = ?) AND ((? IS NULL AND FNAME IS NULL) OR FNAME = ?)

Thanks,

Rick