>- COPY FILE both files, dbf and fpt
>- on the duplicate, set all the memos to empty low level (alter the dbf low level)
>- minimize the fpt
>- then parse the original for memo chunks as suggested above, those chunks you can simply add to the duplicate with REPLACE or the like.
>- note the double/failed records somewhere
>- with bells and whistles: figure out the untouched memo blocks in the memo file, list them for the operator, possibly he can identify missing data.
>
>Create a generic prg and post in VFPX.
>;)
Done already, see here:
https://www.levelextreme.com/Home/ShowHeader?Activator=17&ID=9264Except it doesn't do those duplicate etc checks. Just reads the blocks from the old file and writes records in the new table. Whatever's wrong, leaves empty.
And requires a clean table from which to generate the rebuilder routines. Mind you, the code is old, but then there weren't any changes in the structure of a dbf since then, so it should still work.
Um... what's that, what's the year? There should be a fresher version of it, from at least 2002. I think I already gave it to someone here.