>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