Kbase P115744: Records created in random order on server side
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/12/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Records are getting created in a random order on the server than the order they were created at the client side.
Creating multiple records with autocommit=no
Commit all records to the database with single call to commitTransaction
CAUSE:
This is a known issue being investigated by Development
FIX:
Change bufferProcessNew in query.p as follow:
hQuery:QUERY-PREPARE('FOR EACH ' + hRowObjUpd:NAME + ' WHERE RowMod = "A" OR RowMod = "C"':U).
Change this to use a 'BY RowNum':
hQuery:QUERY-PREPARE('FOR EACH ' + hRowObjUpd:NAME + ' WHERE RowMod = "A" OR RowMod = "C" BY RowNum':U).
If version is 9.1D, the bufferProcessNew is in data.p.