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 ?
Printable View
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 ?
SQL 7 does row level locking by default
um...
Then How can I use it with VB 6.0?
yes, I tried it before. But it is a recordset locking not a row locking....
What kind of cursor are you using?
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?
as soon as you edit the current record, that row will be locked in the database (assuming you don't use a disconnected recordset)