One of my users had some kind of data corruption that trashed part of a
blb file, so that much of it was missing after the dbisamtable.repair
finished.

His last backup was two months ago.

My app actually makes automatic backups every day by copying to a
BUMonday or BUTuesday etc. folder, and I have preserved these on his
hard disk so they will not get overwritten by current operations.

However, when I tried to copy a recent BLB file to his data folder and
then did a repair, I got an "Invalid BLOB offset in BLOB file for
physical record # 1, error fixed..." message for every record and the
BLB file was empty.

Is there any way I can use either a recent or the two month old BLB file
to retrieve the data and insert it into the current file?

DBISAM 2.12 --- it's old but it works for me.

TIA,
Jerry

Jerry


The problem will be that the two files will be out of sync. What I can suggest is more work

1. Do a repair on the existing table
2. Restore the table to a separate directory/under a different name
3. Write a bit of Pascal or SQL to update the memo fields from one table to the other

Roy Lambert

Jerry,

<< However, when I tried to copy a recent BLB file to his data folder and
then did a repair, I got an "Invalid BLOB offset in BLOB file for physical
record # 1, error fixed..." message for every record and the BLB file was
empty.

Is there any way I can use either a recent or the two month old BLB file to
retrieve the data and insert it into the current file? >>

Not without dumping the contents of the BLB and re-matching everything by
hand.  If you want to pursue this avenue, let me know via private email and
I'll work out getting a program to you that will dump the BLB into separate
files.

--
Tim Young
Elevate Software
www.elevatesoft.com