Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Olaf Doschke
  Where is Olaf Doschke?
 Hamburg
 Germany
 Olaf Doschke
 To: rolly padilla
  Where is rolly padilla?
 Roxas
 Philippines
 rolly padilla
 Tags
Subject: RE: CDX File To DBF -Can I Recreate Records
Thread ID: 195404 Message ID: 196700 # Views: 31 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Sunday, September 28, 2008 11:11:01 PM         
   


What's stored in CDX is vallues of the
expression used for the tags. But it's
likely you also deleted from cdx as
it's connected to dbf and zap will
also zap the cdx.

You better had a backup.

If you can get something back, then by this
code:
http://blogs.msdn.com/calvin_hsia/archive/2005/01/05/347388.aspx

Calvian Hsia here explained in detail the
structure of indexes and how to decode
index information.

Don't miss the link to the decoder, which is here:
http://www.calvinhsia.com/default.asp?page=link&file=images/indexprg.htm

As Calvin said it only works with text indexes,
so you may recover the text fields you indexed
and text expression like str(numericfield) or
dtos(date) if you indexed on those expressions,
but not indexes on other field types. And any
fields you didn't indexed are lost anyway.

Bye, Olaf.



COMPLETE THREAD
CDX File To DBF -Can I Recreate Records Posted by rolly padilla @ 9/21/2008 1:36:21 PM
RE: CDX File To DBF -Can I Recreate Records Posted by Anil Sharma @ 9/21/2008 2:01:52 PM
RE: CDX File To DBF -Can I Recreate Records Posted by Barbara Peisch @ 9/22/2008 4:26:45 AM
RE: CDX File To DBF -Can I Recreate Records Posted by Patrick McGreevy @ 9/28/2008 8:06:42 PM
RE: CDX File To DBF -Can I Recreate Records Posted by Olaf Doschke @ 9/28/2008 11:11:01 PM
RE: CDX File To DBF -Can I Recreate Records Posted by Koen Piller @ 9/29/2008 12:00:44 AM