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: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112467 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, November 08, 2006 9:15:19 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 ...

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