Record Lock Help ?

[dineshns]

Hi

I nned to know about record locking

I opened a connection with
adUseServer
and I opened a recordset with
adOpenDynamic and
adLockPessimistic

When another user try to open same record set, How do we check the record lock status

Thnk u in advance

Dinesh

[dineshns]

I use adLockPessimistic to open a record set.

How do I know weather the selected record is locked by another person.

If any body can show me an link to learn Multiuser programming with SQL server and VB 6.


Thank you.

Dinesh

[Cimperiali]

these could help:

http://www.sas-software.nl/devcon/AdoAdvanced.pdf

http://www.vbmysql.com/articles/cursorsandlocks.html
(from second link)

In a situation of high concurrency, with multiple users modifying
the same data, you may need a pessimistic lock type.
With asLockPessimistic, the underlying rows (or table) will be
locked as soon as you begin making changes to the current
record, and will not be unlocked until the Update method is
called.

Thus, another process trying to update same record will fail.
Trap error.

[dineshns]

Thank u for Help

ex.. Sombody (Another User) has Open a recordset with LockPessimistic.

My Problem is, When I am going to open the same record, It gives "Time out error" After 25-30 seconds. Aplication Freeses for 30 seconds.

Is there any way to Check the recordset weather Is it locked or not before openning?

Thank u.

Bye

[dineshns]

Thank u for Help

ex.. Sombody (Another User) has Open a recordset with LockPessimistic.

My Problem is, When I am going to open the same record, It gives "Time out error" After 25-30 seconds. Aplication Freeses for 30 seconds.

Is there any way to Check the recordset weather Is it locked or not before openning?

Thank u.

Bye

[Cimperiali]

There should be a sys table where all locked objects are listed...
try searching help for sysObj on your Db...