That said...I do use buffering on those local cursors to allow me to revert to what it was prior to my changes (as per the last query).
On 11/25/2019 5:29 PM, MB Software Solutions, LLC wrote:
All are saying the same thing...but I know I use the method Charlie Coleman showed me probably 20 years ago using local cursors and having my n-tier framework code handle the updates. I basically get the data into a VFP cursor. For add/edit mode, I scatter the cursor into an object and my edit forms use thisform.oRecord.Whatever for control sources. If user wants to save, edit form sends back signal to calling form which then passes the MyEditForm.oRecord object to the backend for INSERT INTO or SEEK-and-GATHER for update operations. That's a simplified process but that's basically it. But to be fair, I haven't use DBFs in my designs since seeing Bob Lee's n-tier demo at WhilFest in 2002 or 2003. Prior to that, I used local VFP views (table-buffered) for my apps.