Christian,

I don't understand why you expect an error. IB _is_ updating all records
where user_name = 'X', but there aren't any. How is this different from

SELECT * FROM T_Users WHERE User_Name = 'X' ;

(returns no rows), or

n := 0 ;
for i := 1 to n do
ShowMessage ('i = ' + IntToStr (i)) ;

(shows no messages)

Art Metz
AMetz@...

> -----Original Message-----
> From: Christian Gütter [mailto:cguetter@...]
> Sent: Monday, February 05, 2001 8:34 AM
> To: 'ib-support@yahoogroups.com'
> Subject: [ib-support] UPDATE when row does not exist
>
>
> 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).
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://click.egroups.com/1/11231/0/_/_/_/981390169/
> --------------------------------------------------------------
> -------_->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>