>I redid the test with Version 5.5.5 [Build 2152] and get the same problem.
>
>if I change the SQL to bellow, works fine:
>Q.SQL.Text := 'UPDATE ANY_TABLE SET ID = 2 WHERE ID = 1';

What happens if you use a different parameter name than OLD_ID, e.g.

Q.SQL.Text := 'UPDATE ANY_TABLE SET ID = :ID WHERE ID = :XID';

The reason I'm asking is that I think IBO does some magic to parameters by adding OLD and maybe that could interfere with your statement (though I don't remember whether it would use OLD_ID or ID_OLD).

Set