xIRC
March 31st, 2003, 01:48 AM
Why if I open a recordset using the following ->
CursorLocation = adUseClient
RecSet.Open "SELECT * FROM MYTABLE", pCon, adOpenStatic, adLockPessimistic
Why if I open the recordset, does the locktype change ?
I have one prob. When I want to edit data, and call recset.Update
the function call crashes, stating: "The recordset can't be updated, since the record cann not be located since it's last been read." <- something like that.
I know how locking/cursor types work, etc. I know that if you use adUseClient, as your location, you can only choose the adOpenStatic cursor, but why change the locktype if I specify it as adLockPessimistic, why does the thing automatically change to adLockBatchOptimistic ????
CursorLocation = adUseClient
RecSet.Open "SELECT * FROM MYTABLE", pCon, adOpenStatic, adLockPessimistic
Why if I open the recordset, does the locktype change ?
I have one prob. When I want to edit data, and call recset.Update
the function call crashes, stating: "The recordset can't be updated, since the record cann not be located since it's last been read." <- something like that.
I know how locking/cursor types work, etc. I know that if you use adUseClient, as your location, you can only choose the adOpenStatic cursor, but why change the locktype if I specify it as adLockPessimistic, why does the thing automatically change to adLockBatchOptimistic ????