Kbase 35014: Share-Lock Retained After Program Ends When Using Field Lists
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/15/2000 |
|
Solution ID: P5014
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Share-Lock retained after program ends
Using field lists
CHANGE:
Added the FIELDS() phrase
CAUSE:
Using the FIELDS() phrase on a SHARE-LOCK or EXCLUSIVE-LOCK query
CAUSE:
Using the FIELDS() phrase on multiple buffers for the same table where the list of fields do not match
FIX:
Field lists were designed for use with Progress DataServers only.
The 4GL can have issues with field lists which may lead to unexpected record locking so to resolve the problem either remove the FIELDS() phrase from the query or ensure that the same FIELDS() phrase is used in all active queries against the same table.