detaching an fpt file from its dbf file and reattaching it

[DEBWEST]

Does any one know how to do this? I've got a very messed up fpt file. i tried replacing the memo fields, but the bad pointers persist.

So I thougt If I could take off the fpt file,'zap' it reattach it and fill it back up.

Anyone know how?

 

[rgbean]

The easiest way to do this is to create another table with the same memo fields in it. That is the same number and field names. Then just rename the "bad" one, and rename the new the to the right name. Then all should be well.

Note: Depending on the version of VFP and your settings, you may get one error message, but just "Ignore" it if necessary.

Rick

 

[alvechurchdata]

So I thougt If I could take off the fpt file,'zap' it reattach it and fill it back up.

I don't know how old your version of Fox is but the early versions weren't at all fussy about Fpt files. If the Fpt of MyTable got corrupted then the technique was:

  Delete MyTable.Fpt
  Find any other fpt and copy it to MyTable.Fpt
  Use MyTable
  Modify Structure
  Delete the memo field and close the table
  Reopen the table and recreate the memo field

It seemed that Fox didn't actually check the structure of the FPT file - it was happy just to find an FPT file with the right name.

Geoff Franklin

http://www.alvechurchdata.co.uk