I use a homemade framework for my normal work which utilizes a concept which requires 2 copies of the same table in a private data session. The copy of the main table is used in a grid for navigation purposes (MyTable1), and you add to or modify the main table (MyTable). My main data entry form class uses a pageframe with the grid populated by fields from MyTable1 on page 1 and all other pages are populated by fields from MyTable. The Form buffermode property is set to: Optimistic.

Perhaps this approach would now be considered flawed, but the author claims he felt it was appropriate for earlier versions of VFP that perhaps had less readonly traits then presently in VFP9.

Anyway, it works for me for what I normally do. I do encounter issues sometimes as I did recently. I would like to understand better the relationships between the two tables which are identical at start.

There seems to be a lag time between updating the copy, MyTable1, after I change a value or add a record in MyTable. I notice this because the form updates all the tables listed in a form property by parsing then spinning through the property value and updating all tables when the Save button is pressed. The tables themselves have their BufferOverRide property set to 3 (OptomisticRowBuffering).

After I update the main table, MyTable, do I have to update the copy as well? If not, is the lag time before MyTable1 gets updated predictable? Is it adjustable?

Thank you in advance,

Gary De Lecce