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