Commit before deletion during Loop

[Fenton]

Just thought I'd share a little difference introduced in 7. I was taking a file that needed cleaning up, appending data from a field in multiple duplicate records into the 1st instance record (the data was from a flat file that chopped long lines into pieces).

I was using a self-relationship to append the data from later lines back onto a field in the 1st instance record, then deleting the duplicate records. I watched it during the loop. It would append the data to the 1st instance record fine.

But when the later record was deleted, the appended data would disappear. Because I hadn't used Commit Record right before each deletion, the deleted record took the data set by its self-relationship with it. A simple Commit at that point fixed it.