Subject UPDATE when row does not exist
Author Christian G├╝tter
Hi,

I am wondering why this statement does not
return an error:

UPDATE T_Users SET User_Name = 'X', First_Name = 'X', Last_Name = 'X' WHERE
User_Name = 'X';

The table 'T_Users' consists of the three above fields and
'User_Name' is the primary key.
It is so weird because a user with the 'User_Name' 'X' does not
exist. So I expected the statement to fail.
But there is no error - and before and after executing the statement
there is no user 'X'.

Does this mean IB is able to update records which don't exist?


TIA,

Christian


P.S.: I am using IB 6 (Wise installation).