Kbase P52758: Error 16 loading df and changing records in the same transaction
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Error 16 loading df and changing records in the same transaction
SYSTEM ERROR: bffld: nxtfld: scan past last field. (16)
DO TRANSACTION:
RUN prodict/LOAD_df.p(INPUT "c:\AddNewField.df").
RUN c:\PopulateNewField.p.
END.
CAUSE:
The database schema changes are not committed. The above code try to assign a field which isn't yet in the database.
FIX:
The database schema changes should be committed before updating the records.
This can be done by separating the code in two transactions as follows:
DO TRANSACTION:
RUN prodict/LOAD_df.p(INPUT "c:\AddNewField.df").
END.
message 'At this point the database SCHEMA changes are already committed'.
DO TRANSACTION:
RUN c:\PopulateNewField.p.
END.
message 'At this point the database RECORD changes are already committed'.