Hi all,

A preferences and practices question.

I have a VFP6 app that I am implementing and maintaining (written by others) that in the course of the user editing records, the developer does a lot of copying the records being updated out to a temp file, processing the edits, appending the records back to the tables, then deleting the original records.

It seems that this would be a performance hit when the edits encompass a lot of records (this is a work order and inventory app), as well as requiring a pack every once in a while. It just seems easier to edit the record directly, but is this possible in a multi-user network app? It is a procedural rather than OOP style app. Looks more FPW2.6 than VFP. I want to know is this the best/preferred way to do this?

TIA