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
 To: ed hardy
  Where is ed hardy?
 new york city
 New York - United States
 ed hardy
 Tags
Subject: RE: Database, Table and CDX Corruption Issues
Thread ID: 107553 Message ID: 114862 # Views: 59 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Friday, December 01, 2006 6:51:42 PM         
   


> I'm wary due to my dBase experiences. Maybe I shouldn't be so wary, but my approach evolved from my dBase era, finding a string of binary zeroes slashing through my dbf tables after power disruptions.
>
> Currently, I have applications running for about eight years in a bad power environments, with few if any problems related to file corruption.
>
> select * from customers into cursor x
> use in customers
> *...process x...
> use customers
> *...update customers...
> use
> use in x
>
> Essentially I minimize the existence of open tables.
>
> Server loads are never heavy in this small business environment, so I can open and close a table in at least 1/200th of a second, with confidence that data is stored to disk.


Hi Ed,
Yes a good point you raise in your thread... If you do not have the table
open, it will not become corrupted. However, with the stock VFP forms and
the use of a data environment, all tables involved in the form are opened
when the form opens, and only closes when the form is closed. This aspect
adds to the potential of corruption. Again, one can choose to custom code
and open and close tables only when required, however most do not do this.
The point you raise is another way to minimize the potential for corrupted
tables... open perform your operation, write and close.
Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

ENTIRE THREAD

Database, Table and CDX Corruption Issues Posted by Pete Sass @ 9/21/2006 12:31:05 AM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 9/21/2006 2:34:37 AM
RE: Database, Table and CDX Corruption Issues Posted by Emerson Reed @ 9/21/2006 4:02:41 PM
RE: Database, Table and CDX Corruption Issues Posted by JLW Wade @ 9/22/2006 10:22:22 PM
RE: Database, Table and CDX Corruption Issues Posted by ed hardy @ 12/5/2006 8:51:45 PM
RE: Database, Table and CDX Corruption Issues Posted by ed hardy @ 12/1/2006 6:41:51 PM
RE: Database, Table and CDX Corruption Issues Posted by Pete Sass @ 12/1/2006 6:51:42 PM
RE: Database, Table and CDX Corruption Issues Posted by Terry Parkinson @ 7/11/2007 4:31:50 PM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 7/11/2007 9:50:09 PM
RE: Database, Table and CDX Corruption Issues Posted by Terry Parkinson @ 7/12/2007 5:01:20 PM
RE: Database, Table and CDX Corruption Issues Posted by Riche Evardo @ 7/11/2007 8:14:00 AM
RE: Database, Table and CDX Corruption Issues Posted by TabzSki Cubita @ 10/25/2007 11:27:02 AM
RE: Database, Table and CDX Corruption Issues Posted by Rudy Hendrawan @ 12/6/2007 7:24:49 AM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 12/6/2007 12:31:10 PM
RE: Database, Table and CDX Corruption Issues Posted by Andrea Mariottini @ 12/6/2007 3:00:51 PM
RE: Database, Table and CDX Corruption Issues Posted by Stoycho Stoychev @ 1/24/2008 6:11:10 PM
RE: Database, Table and CDX Corruption Issues Posted by suhas hegde @ 12/6/2007 3:02:19 PM
RE: Database, Table and CDX Corruption Issues Posted by Floyd Reeves @ 4/22/2018 2:22:17 AM
RE: Database, Table and CDX Corruption Issues Posted by Tore Bleken @ 4/22/2018 8:06:34 AM