Kbase P69133: Attempting to load temp-tables that are part of a dataset us
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
Attempting to load temp-tables that are part of a dataset using FOR EACH with a join
** <file-name> already exists with <field/value...>. (132)
CAUSE:
Customer did not understand that for each record in the inner table of the join that matches the same outer record will also be returned. They were attempting to insert the outer record multiple times into the corresponding temp-table.
FIX:
Modify the source code to use BREAK BY then check the FIRST-OF function for the outer table(s) and only insert a record into the corresponding temp-table when the FIRST-OF function is true.