Helen,

> Try this:
>
> Update The Field set id = 'FOURTH' where id='FIRST'
>
> and see what you get!

Assuming that "The Field" means TheTable, I tried and I got 1 affected
row as I expected, thank you very much. :-P
Just a note: I haven't tested with the latest IB/Firebird, but let me
say that if this has changed lately then it's a problem: it should
behave exactly as I have outlined.
Ciao
--
____
_/\/ando