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


Hi. Can anyone help me, please? I have accidentally deleted records from my DBF file while
coding the program for my project. The CDX file remains intact as it was not opened during
program testing. Please help me recreate records from my CDX file back to DBF file.

this is my sample command which did the damage:

use File1.dbf
If file('file2.dbf)
use file1 ***---> THIS IS SUPPOSEDLY File2.dbf
zap ***---> which resulted in my loss of records...
else
copy structure to file2.dbf
use file2
endif

append from File1.dbf for trandate>ctod('01/01/2008')
.
.
.
* * * *

Thanks a lot.

Rolly



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