Running an internal 'update' procedure using 'by-reference'.
After successfully populating a static ProDataSet with filtered query and updating data in the temp-table I couldn't figure why the dataset accept changes method didn't update the table. The BI table contained all of the before images of the changed records and after the accept-changes method the BI was cleared, as you would expect. The source data has ROWID identified as the only key which is associated to an additional rowid field in the temp-table. The workaround has been to include a loop through the before image table (with a SAVE_ROW_CHANGES method) immediately prior to the DATASET ACCEPT-CHANGES method instruction.
Why would the BI loop with SAVE-ROW-CHANGES work whilst the DATASET ACCEPT-CHANGES be ineffective? Any clues?
save-row-changes updates the changed rows to the database or data-source. accept-changes or reject-changes works on the dataset (not the data-source) either clearing the before or after images records leaving dataset in the modified or original state ready for the next set of changes.
Miles
Well that explains it! Thanks Miles.
Steve
On Mon, Apr 26, 2010 at 6:58 AM, Miles Klettke <