you don't lock records in sql server. do it:

xhnd=sqlconnec(.....
sqlexec(xhnd,;
"update customers set surname='cvvcxs', age=44 where name='xxx'")
sqldisc(xhnd)

use views much easier. you can do something vfp and you don't need lock.