Daniel Albuschat wrote:

> I tried the same query with IBPP, a lower-level Interbase/Firebird API and
> it worked as expected without mixing any values, so I highly suspect
> IBObjects as the culprit.
>
> If you need more background information to reproduce the problem,
> please let me know.

Try using id_add and id_add1 - I've seen problems when IBO rebuilds the
SQL but gets the order wrong. Bear in mind that the ACTUAL SQL has '?'
and needs all four values in the right order.
Not an answer, but just an explanation of what can go wrong ;)

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php