Row Locking for VB and SQL 7.0

[Smallkeung]

Is it possible to perform row locking with VB and SQL 7.0 ?
if yes, how to do it?

if no, is it possible to use recordset lock instead of row lock? in the real world, what method will be used ?

[Clunietp]

SQL 7 does row level locking by default

[Smallkeung]

um...
Then How can I use it with VB 6.0?

[Smallkeung]

yes, I tried it before. But it is a recordset locking not a row locking....

[Clunietp]

What kind of cursor are you using?

[Smallkeung]

Client and Server both of them....

You mean I just need to use vb provide function to do the record lock. Then It will be a Row Lock, not a recordset lock. right?

[Clunietp]

as soon as you edit the current record, that row will be locked in the database (assuming you don't use a disconnected recordset)