Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Protecting Tables against power fail - FLUSH doesnt work
Message
From
15/11/2001 23:00:28
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
15/11/2001 22:11:25
Malcolm Sheldon
Benchmark Consultants
Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00582519
Message ID:
00582537
Views:
24
< SNIP >

If you want to minimize disruption in the face of power outages you've got a couple of choices:

- protect all servers, workstations and networking equipment (switches, hubs, etc.) with UPSs

- use a database back end that implements transaction logging (SQL Server, Oracle, etc.) which is much more tolerant of these kinds of faults.

A number of years ago I remember hearing about someone who designed a transaction-logging process for VFP which was supposed to give these benefits. Can't remember anything about it, though.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform