>>>One of our clients has a corrupted table. I have FoxFix, but either it's not working or I don't know how to use it. It looks to me that the data is shifted and I'm getting a whole lot of "delete flag corruption" errors, but I don't know how to fix it. Can anyone help me??
>>>Thanks,
>>>Elyse
>>
>>1. What version of Fox?
>>2. How big is the DBF at the moment (in bytes), do you have any way of knowing how big it should be?
>>3. Does it contain sensitive data?
>>4. Are there any memo fields?
>>5. Is it a free table or referenced by a DBC?
>>6. Do you have details of any index Tags stored elsewhere?
>>
>>If it's small'ish (zips down to a few meg) and does not contain sensitive data - then you could send it to me and I'll see if I can fix it.
>>
>>Rolling your own recovery tool (not meant to be comprehensive):
>>Text fields are the easiest to recover - most other data types require work to read/convert to text.
>>Copy the table and change the extension to .TXT
>>Open the text file using Notepad (if it's not too big) or Modify File in Fox - how does it look.
>>Delete the file header and save.
>>Use low level file I/O to copy the text file into another new text file, this time inserting chr(9) as the field delimiter and chr(13) as the row delimiter.
>>Create a new temporary table and append the text file into it.

>VFP 7 - I don't know how large the file should be. There are memo fields. It is part of a DBC. I deleted the index tags. It does not contain sensitive data - I'll send it to you and would be extremely grateful if you can fix it. I have info for this table stored in Stonefield's Database Toolkit if that helps.
>
>Thanks!

In Internet Explorer, right click on the envelope above and 'Copy Shortcut' then paste this into your new mail 'TO' field, delete the 'mailto:' part. I will acknowledge receipt. Please include details of the correct structure and a separate mail with the zipped FPT file.