> 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

reminds me of that beatle song, "Yesterday."

Yesterday,
All those backups seemed a waste of pay.
Now my database has gone away.
Oh I believe in yesterday.

Suddenly,
There's not half the files there used to be,
And there's a milestone hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say.

Now all my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
I knew my data was all here to stay,
Now I believe in yesterday.

But seriously. I do hope you made a backup first. Otherwise look for those repair tools on the web.


Boudewijn Lutge®ink
http://www.vfpdevelopers-online.com
The truth will set you free, Ken knew the truth!