>I am attempting to update the customers database by running my SDT update.exe that I have used for several years. I am getting the message that the FPT file for one of the tables is missing or invalid.
>
>I backed up the tables and DBC files before running the update.exe and the table in question is OK. I can open it and browse it. The issue seems to be that the update.exe 'thinks' there is a missing or invalid FPT when there isn't. I have tried copying the good backed-up files into the original folder they were from where the update is being executed and that does not work.
>
>Any ideas or suggestions?
>Thanks very much.
I have seen this when there are corrupted records.
Write something simple like:
SCAN
WAIT WINDOW TRANSFORM(RECNO()) NOWAIT
SCATTER MEMVAR MEMO
ENDSCAN
It will fail on the bad record. To correct it, load that table in the hexeditor and change the 4-byte memo data to all ASCII-0 bytes.