>Hi All,
>I have an old Foxpro 2.6 app on a disk and am trying to get some data from it.
>It looks like a complete small app but has no .pjx or .fpc file.
>My problem is a table that looks as if someone opened and SAVED in Lotus. I have a .cdx and .fpt file. Is there a way to get the data from the .fpt file and connect it to the appropriate record?
>
>No backup can be found.
>
>Thanks
>Peter
Peter,
Getting the data from fpt is the easy part. Hard part is in associating them with correct records and as I understand the records are missing.
A dbf with memo fields keep 'block pointers' in memo field position. ie:
table : name c(20), memofield1 m, somefield d, memofield2 m
might have data as :
John Smith, 102, 03/02/2003, 105
102 and 105 are block pointers (browsing shows Memo, hexeditors show 102 and 105 in plain string padded left to 10 bytes - fox2x).
An fpt has memo blocksize in its header and default is 64 (hex 40). 102 then means offsett 102*64.
Without having block pointers I don't know of a way to associate the fpt data with real records.
Cetin