>>Using memos in my apps (not realy much) and for develpment (huge) not a single one in over 10 years.
>>
>>What causes memo corruption? I see not much more then instable hardware including powersupply. But this could kill relationships as well.
>
>
>So, when the corruption occurs, to restore the indexes I think that you run your reindexer procedure... to restore the link to FTP files do you edit the DBF header ?
If I would be realy in need of I would use a hexeditor to manipulate the DBF. The problems with memos are more that a write - error occurs and that the dbf - ftp runs out of sync. This is harder to fix. I never run into this so I never have done.
My point is that the memo problem is overvalued. Lets asume the VFP engine works perfect for the problem. All the stuff that cause a memo file to go out of sync will do the same thing to a cdx file. It might even bring the dbf itself out of sync. A dbf has a lenght information, and if something failed the wrong moment, file length does not fit to the lenght info.
The only problem with a corrupted file I ever had in VFP was a DBF with a corrupted lenght.
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]