|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Recordset Locking |
|
From: |
Harlan |
|
Date: |
3/8/1999 4:50:58 PM |
|
IP: |
206.222.20.2 |
different lock types:
read-only: default lock type, most restrictive, no update can be made.
batchOptimistic: updates records as a batch,instead of individual locks being created and released as changes are made to the database. The lock is placed on all the records for the short time they are updated, and then the lock is removed.
Optimistic: creates a lock on a record when a change is implemented on a record by using the update method.
Pessimistic: locks the record as soon as the data source knows a reocrd will be edited. The data source usually notifies when using the edit method.
Note: when a record has a lock set on it, it can't be read from. So your selects skip any records with locks on them.
this stuff should all be covered in both the asp help file, and any good asp/vb/vbscript book. I personally like wrox press asp professional. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
