Lightening


While trying to pack a table, got the error:

Memo file xyz.fpt if missing or is not valid.

The file is there and there is data in the memo field for some records.




Re: How to resolve Invalid *.ftp file error


Re: How to resolve Invalid *.ftp file error

dni

It is possible to need to recover the file with ftp extension. I also had few times that error in vfp 9. I opened files with vfp 7 and worked fine...







Re: How to resolve Invalid *.ftp file error

Vladimir Zografski

You can try also this code

FIrst of all backup the files.
Code Snippet

lnValidate=set('tablevalidate')
set tablevalidate to 0
use yourfile exclusive
copy to temp
zap
append from temp
set tablevalidate to lnValidate







Re: How to resolve Invalid *.ftp file error

Lightening

Thank you all for your reply, as always.

I luckily has a backup table. I used a similar method Vladimir posted here.

use mytable excl

modi stru

delete the memo field

save the change

add the memo field back.

now I can pack and zap.