Kbase P9405: Errors using Share-lock with Dataserver SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
MS SQL DataServer
Progress 9.1B
Progress 9.1C
Progress 9.1D
OpenEdge 10.x
SYMPTOM(s):
Getting errors updating records in SQL server database
The record was updated while you were holding it. (2087)
Record was changed since you have read it (1071)
Unable to update <filename> Field. (142)
Using SHARE-LOCK
Using -Dsrv TXN_ISOLATION,1
CAUSE:
By default, dataserver ignores the 4GL SHARE-LOCK option when used in Progress statements. NO-LOCK is used instead.
FIX:
This is an expected behavior.