A programmer here at work is having trouble with losing data when there is a power failure. Since some of our stores have lost data that was apparently saved, he does tests that involve turning power off, to simulate a power failure.
The sample program does a FLUSH,
and also closes tables and database (which I consider overkill, but just in case...). We already disabled write cache on the hard disks. But still, data gets lost when power is turned off.
Is there anything else we have to watch out for?
Would a later version of VFP help?
TIA,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)