Peter,

t> UPDATE IBAT SET IB_QTY=IB_QTY--12 WHERE CODE='A'

t> does nothing whatsoever, no update, no exception, just nothing.

I believe "--" introduces a comment for the rest of the line.

I suggest you embed spaces in the queries you generate, as the above
is just one of the many unwanted outcomes you're bound to if you
don't.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================