Sir,

Sorry, I do not have a "better alternative" to suggest. The concept "buffering" if properly understood and implemented should be the best alternative for us. It has all the "PROs" but some "CONS" if not properly used.

You must have heard .."NEEM HAKEEM, KHATRA-E-JAAN"... meaning incomplete knowledge can prove dangerous.
I tried "Buffering", on an application built on VFP6, running very "stable" for three years, no data disappearing, no table corruption, no problems at all. But with my first attempt at "VFP9" and "buffering" all the aforesaid problems emerged.

So, though I did not revert to VFP6, I simply resorted to the old ways of "Manual" locking of tables, "Set TAbleValidate to 0" and the use of FLUSH command after every WRITE.
Since then the Electricity Supply situation has NOT improved, the Employees at my Clients' have not changed their attitude and become more responsible, (CTRL + ALT + DEL)/ and improper shutdown are common, but despite this, I hav'nt received a "Table Corruption Complaint" as yet.

If you understand buffering and your routine is working well, no need to change anything. As experts here often say ..don't repair what is not broken.


kulwant
(Help Save the TIGER. Save Wildlife. Live & let Live)