Consultor Eletrônico



Kbase P19265: Getting error 2087 updating last record in FOR EACH loop
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   13/02/2003
Status: Unverified

FACT(s) (Environment):

Progress 9.1C

FACT(s) (Environment):

MS SQL DataServer

SYMPTOM(s):

Getting error 2087 updating last record in FOR EACH loop

The record was updated while you were holding it. (2087)

CAUSE:

Not using RELEASE <buffer> when records are updated inside DO WHILE block.

FIX:

Use REPEAT block instead of DO WHILE or have a RELEASE statement after buffer is updated.