Hello Andrew!

Using the same reference, as with UPDATE - SQL, maybe it's typo error on the part of MS based on reading it's related command DELETE - SQL which locks record also. As with the REPLACE, the statement says "when updating multiple records in a table" which to me, it does mean that if it's more than one record, it locks entire table but one record locks the current record only.

>Hi Jess,
>
>Here's a quote from the MSDN UPDATE - SQL topic:
>
>Unlike REPLACE, UPDATE - SQL uses record locking when updating multiple records in a table opened for shared access. This reduces record contention in multiuser situations, but may reduce performance. For maximum performance, open the table for exclusive use or use FLOCK( ) to lock the table.
>
>Which, to me, says that UPDATE - SQL does not lock the whole table.
>
>Cheers,
>
>Andrew
>
>

---

>
>>>Hi Jess,
>>>
>>>As far as I understand your post,your
>>>

UPDATE – SQL      Entire table

>>>Conflicts directly with the Hacker's Guides's UPDATE uses record locking while REPLACE locks the entire table.
>>>
>>>Care to elaborate?
>>
>>If that so, it's a conflicting statement with what the MS Programmer's Guide Chapter 17 is saying. Who's telling the truth now?
>>
>>Confused...