Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data lost on power failure
Message
From
27/09/2007 08:50:48
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Data lost on power failure
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01257118
Message ID:
01257118
Views:
81
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)
Next
Reply
Map
View

Click here to load this message in the networking platform