> Please help me recover my records from CDX file. I have accidentally Zapped my DBF file.
> I have retained, however, the CDX as it was not opened at the time i issued the zap command.
>
> here's a sample of my code:
>
> Use File1.dbf
> If Found('File2.dbf')
> Use File1.dbf ***----> THIS IS SUPPOSEDLY File2.dbf
> ZAP *** which resulted in my loss of data.
> Else
> Copy Structure to File2.dbf
> Use File2
> Endif
>
> Append from File1.dbf for Trandate > ctod('01/01/2008')
> .
> .
> .
> ******
>
> Thanks a lot.
>
> Rolly
Rolly,
I may not understand you correctly, but according to my knowledge the CDX file is not storing any reccords. The CDX file is storing the index information of your table.
Now if you have accidentaly zapped your table and not deleted the CDX file, than there is no harm done to your CDX file. The reccords in your table are lost, definitely.
If you are able to restore your reccords from a backup table and if you are succesful you should be able to make use of your old CDX file as well.
However I believe you are looking for something quite different than what you are asking and I am not able to see what your question actualy is. Your code is a complete mystery to me
I am anxious to know what is the real question.
Best regards,
Koen