Kbase P107645: Update statement is not following error handling properly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/9/2009 |
|
Status: Verified
SYMPTOM(s):
Update statement is not following error handling properly
Run time error happens in the update statement
block that contains the update have an error processing
A possible runtime is error 132
User enter a duplicate index value for a unique index
** <file-name> already exists with <field/value...>. (132)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
This is expected behavior. The documentation states:
-If an error occurs during UPDATE statement input Progress retries the data entry part of the statement and does not do the error processing associated with the block that contains the statement.
FIX:
Use NO-ERROR option to allow the normal flow of the code followed by ERROR-STATUS:ERROR to trap the ERROR and handle it.