Kbase P118378: FOR EACH query without NO-LOCK displays duplicate records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/23/2011 |
|
Status: Unverified
SYMPTOM(s):
FOR EACH query without NO-LOCK displays duplicate records
FOR EACH query without NO-LOCK repeats first records on the display
The following query is tested against DB2/400:
FOR EACH <table name>:
DISPLAY <table name>.
END.
FACT(s) (Environment):
ODBC DataServer
OpenEdge 10.1x
CAUSE:
Bug# OE00131989
FIX:
The workaround is to use NO-LOCK on the query as:
FOR EACH <table name> NO-LOCK:
DISPLAY <table name>.
END.