Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Looking for a one-line command to repair two table recor
Message
 
To
14/02/2001 14:21:55
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00475674
Message ID:
00475979
Views:
51
Cindy,

Sometime during testing, I wiped out the first two records of a new table I had been testing with. The last two records in the table replaced the first two records in the same table. So I had records #1 and #2 which matched records #109 and #110. It's not a lengthy table, only 110 records long.

And I do have an old table with most of the same fields in them intact. So instead of manually entering the 40 or so fields to repair the two records that I wiped out, I thought I might be able to move the fields from the old table to the new table, but only the first two records since those were the only ones that got messed up. And I would only move the fields from the old table that matched the fieldnames in the new table.

I could write a short program to do it for me, but I thought that maybe there was an easier way than that because it's only for two records with about 40 fields in each record.

Manually entering the data might take 30 minutes to an hour I estimate because some fields are memo fields.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform