Thanks for your suggestions guys.

I take your points about the transactions....I'll double check for
that situation in my app.

I was testing it with IB_SQL, so there were no other transactions
involved, but I think I might have been testing the wrong field and
confusing myself. I'll reengage the brain and have another go.

Thanks for the advice.
Steve