Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for a one-line command to repair two table recor
Message
 
À
14/02/2001 14:21:55
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00475674
Message ID:
00475979
Vues:
56
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform