Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for a one-line command to repair two table recor
Message
De
14/02/2001 15:37:06
 
 
À
14/02/2001 15:27:28
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:
00476004
Vues:
35
>You don't need a one-liner then.
>
>Go to good record. Type SCATTER MEMVAR in the Command Window. Go to record to overwrite. Type GATHER MEMVAR in the Command Window. Repeat for the other record.
>
>>Cindy,
>>

Use SCATTER MEMO MEMVAR and GATHER MEMVAR MEMO since there are memo fields involved.


>>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.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform