Subject Re: DBT file corrupt
From Paul Nielsen <pnielsenz@cs.com>
Date Tue, 23 Jun 2020 19:23:12 -0400
Newsgroups dbase.getting-started
Attachment(s) Error message.png

Hi Ken,

I came across this post when I had a bad DBT message in a production database.

The program worked great to fix two errors which showed up in a database of about 43600 records. However, with dBASE10 there is an error message that shows up immediately after hitting the process button, which I have attached. I thought at first that this was because fixed.* is left in the dUFLP directory, but even when the three files are deleted, they reappear immediately when the program is run, and I get the same error message. Clicking on Ignore allows the program to continue to completion.

I haven't tried just FixDBF7.prg, nor have I tried to determine the cause of the error. Maybe someone with more experience can find it.

It takes about 5 minutes for a local scan of 43667 records in a DBF file of 12MB

Anyway, the author Paul van House deserves a heartfelt thank you for the program, and you for the post.

Paul

Ken Mayer Wrote:

> On 12/14/2017 12:08 PM, Phylsys wrote:
> > Have a specific record that once selected shows pop up of corrupt blob file. Level 7 dbf.
> > Is there a utility that can repair it. Is it just an index of the dbf file for the memo field? A decade or more ago there were several programs that dealt with corrupt indexes...But it was for a level 5 dbf. Can I delete the records say for one before and 5 more after...Then insert blank for 5 records and then re-enter the data?
> > Or will, once it reached the corrupt index, hang up or fail?
>
> In the dUFLP are two programs you might want to try, but you should back
> up the tables first ...
>
> FixCorruption.wfm
>    and
> FixDBF7.prg
>
> (The dUFLP is a freeware library of code, see the signature block at the
> bottom of my post ...)
>
> Ken
>
>
> --
> *Ken Mayer*
> Ken\'s dBASE Page: http://www.goldenstag.net/dbase
> The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
> dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
> dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm