Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112655 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, November 10, 2006 1:18:06 PM         
   


> > > The problem is that I'm too curious and cannot live with this question. ;)
> > >
> > > Then, by all means, we should get the answer as soon as possible. First aid is informed and we have an emergency room ready for you.
> > > Send the file and we'll see what we can do. Remember however that I will be in Germany for the rest of the week (DevCon).
> > >
> > >
> > > Boudewijn LutgeĀ®ink
> > > The attitude of "An eye for an eye and a tooth for a tooth" will make this world toothless and blind (Ghandi)

> >
> > You can download the files at: ftp://foxite@ftp.folhamatic.com.br
> > Password: vfp
> >
> > There's a dbc named simples and the corrupted table is named movto.sql.
> >
> > Don't mind about sql extension, is just to "hide" that we are using dbf files.
> > The idea of use this extension isn't mine. Particularly I hate this... ;)
> >
> > Emerson Santon Reed
> > http://weblogs.foxite.com/emersonreed
> > http://thespoke.net/blogs/emersonreed

>
>
> Hi,
> I ftp'ed down you zip file. I used CMrepair.app and opened up the Moveto.sql
> table (really a .dbf you renamed to file extension .sql).
> I changed the number of records to 1566. This low level writes to the table
> file header "SO MAKE SURE YOU BACKUP ALL YOUR TABLES AND MEMO FILES", in
> fact backup the entire folder.
>
> Anyway the change to Number of records 1566 fixed your table issue and you
> can now again browse it without any errors. Download CMrepair from out
> download section here and copy the CMrepair.app into the same folder as
> hour corrupted table. From the VFP command window type in:
> DO cmRepair
> Next the cmRepair main screen will appear. Using the spinnerbox for
> Number of records: move this value to 1566
> Exit out of the cmRepair.app
> Now user Moveto and browse
> Voila... all fixed!!
>
> Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Hi Pete.
Firstly, tks for your answer.
I know that you're working a lot and don't have too much time available.

I'm using CMRepair a long ago.

What is intriguing me is the fact that VFP in one machine is capable to repair the table without external resources (not at runtime) and other machines with the same VFP version cannot.

Maybe I haven't used the correct title topic... forgive me.

Emerson Santon Reed
http://weblogs.foxite.com/emersonreed
http://thespoke.net/blogs/emersonreed

ENTIRE THREAD

Table has become corrupted Posted by Emerson Reed @ 11/6/2006 2:58:37 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/6/2006 4:12:22 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/6/2006 5:07:20 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/7/2006 5:41:44 PM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 8:30:02 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/7/2006 11:12:05 AM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 11:51:15 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/8/2006 11:43:02 AM
RE: Table has become corrupted Posted by Pete Sass @ 11/8/2006 9:15:19 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:18:06 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/9/2006 1:00:12 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:26:14 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/10/2006 4:49:31 PM
RE: Table has become corrupted Posted by Bob Brook @ 11/10/2006 5:09:17 PM