>>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!
Elyse Pomerantz