Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: VFP and Table Corruption
Thread ID: 102885 Message ID: 102885 # Views: 112 # Ratings: 5
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Saturday, July 29, 2006 8:33:31 PM         
   


Hi,

I just had to post this thread for VFP programmers in general.

I have been with Fox software since the mid-80's. It has been
my personal experience that VFP; DBC's, CDX's and tables do
experience corruption issues at a far higher level that other
backends. This has been my personal experience end of story.

The core Foxite team knows this.. so lets not slip this under the
carpet and look to correct prior to getting a system into
production to then experience ongoing file corruption issues.

There have been several threads of late on corruption issues with
VFP backends. Now faced with this, please understand that the
simple issuing of a "FLUSH" command after a tableupdate() will
resolved 99% of potential corruption issues in most cases.

Please ensure that you have an ON SHUTDOWN event in all your
applications to save and flush the data to disk. This can
resolve the user that simply reboots his/her computer with
VFP files open. Come on now, program for ways to gracefully
close things down as this will happen.

I you do not have FLUSH commands and do not have adequate error
trapping and you do not have any ON SHUTDOWN events, then shame
on you.

Ensure you have appropriate UPS backend power to your database
servers including the servers where VFP backends are stored.
I get extremely "pi$$ed" where clients stick their VFP backends
onto servers where these servers are not treated in the same
matter as they treat their SQL-Server and Oracle servers. So
why put UPS on an Oracle server, but maintain large VFP databases
and not put a UPS here?

This is not "brain sergery" folks, just good network management
for database servers and lay this out as a requirement to your
clients.

Gees I have several very large VFP backends and they perform
just fine, but I have all the appropriate network measures
applied in my code and do have UPS's on all my servers.

I just wanted to convey this to VFP programmers in general as to
what to really look at, and assess what you have done in your
code for your database applications.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

COMPLETE THREAD

VFP and Table Corruption Posted by Pete Sass @ 7/29/2006 8:33:31 PM
RE: VFP and Table Corruption Posted by Boudewijn Lutgerink @ 7/30/2006 9:36:21 AM
RE: VFP and Table Corruption Posted by Ken Murphy @ 7/31/2006 2:22:21 PM
RE: VFP and Table Corruption Posted by Dexter Carlit @ 7/31/2006 3:33:57 PM
RE: VFP and Table Corruption Posted by Pete Sass @ 7/31/2006 4:15:34 PM
RE: VFP and Table Corruption Posted by Ken Murphy @ 7/31/2006 4:43:52 PM
RE: VFP and Table Corruption Posted by Martin Sellwood @ 7/31/2006 4:54:59 PM
RE: VFP and Table Corruption Posted by Pete Sass @ 7/31/2006 7:15:16 PM
RE: VFP and Table Corruption Posted by Ken Murphy @ 7/31/2006 8:42:45 PM
RE: VFP and Table Corruption Posted by Eric den Doop @ 8/1/2006 8:59:46 AM
RE: VFP and Table Corruption Posted by Pete Sass @ 8/1/2006 1:17:15 PM
RE: VFP and Table Corruption Posted by Eric den Doop @ 8/1/2006 1:47:30 PM
RE: VFP and Table Corruption Posted by Salwan Ravi @ 8/1/2006 9:38:56 AM
RE: VFP and Table Corruption Posted by Mustapha Bihmouten @ 8/1/2006 11:20:59 AM
RE: VFP and Table Corruption Posted by Pete Sass @ 8/1/2006 1:55:57 PM