>>How can I use the row lock in MS SQL 7.0 with VFP ?
>
>That would depend on what you want to do with it? In general, SQL Server handles the application and removal of locks (The default Transactional Isolation Level is Read Committed). When you read data, SQL Server will apply a shared lock. When you change data, SQL Server will acquire an exclusive lock and hold it until the end of the transaction.
>
>It is possible to override the default locking behavior by changing the Transaction Isolation Level or using lock hints. The former is the perferred.
>
>-Mike
Thanks for your advise
I will try to locate more information about that.
K.L.Ma
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only