Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table corruption. VFP8 flavour
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00817446
Message ID:
00818231
Views:
17
After Yuris:
create table tmptab (fld1 c(10))
for ia=1 to 10
insert into tmptab values (padl(ia,10,"0"))
endfor
use
USE tmptab.dbf
use
?strtofile(filetostr("tmptab.dbf")+"HELLO", "tmptab.dbf")

*------------------
You cannot open DBF in VFP8, but running:
DO atfixdbffpt WITH "tmptab.dbf", 4,,,1,.T.,2
I got next info, and tmptab is OK. I clearly shows what's wrong and is it fixed. Do you get any similiar?

Visual FoxPro file: TMPTAB.DBF | Size 444 Bytes.

From Data Start, Total RecSize, Reccount, FieldCount
Filesize 10
Header Block 328 11 10
Data Block 328 11 10 1
Data offset 11

- Field info Ok.
- First field info Ok.
- There are more than one field and the last field info is Ok.
- Space for DBC info Ok.
- Record size from the field info and offset are Ok.
- Record count from file size, header and actual data are same (Ok).
- Wrong file size. There is some garbage after the last record.
Original size 444 Bytes Fixed size 439 Bytes

- First letter of the field's Name, Rest Of the Name, Type, Length
Ok? Yes Yes Yes Yes

Table 0riginal Hdr.....:

Table Fixed Hdr........:

- FPT file, Memo flag, Memo field
No No No

RESULTS (Repair mode 4):
- TMPTAB.DBF is corrupted and REPAIRED!

- No Backups done.

Copyright (C) 2003 Arto Toikka.

Even AtFixDbfFpt a freeware (except the source),
you can send USD $35 payment to the copyright owner for a
future development of this tool and get (through Email)
upcoming version where corrupted field block can be fixes,
manual with examples, the source + source upgrades for a year.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform