Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving Old Table data to New Table File Structure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00385162
Message ID:
00385199
Vues:
23
>I would like to move old D:\Schedule\Schd.dbf to D:\Newschd\Schd.dbf.
>Which copy command would do the job?
>
>1. I want this command to overlay the current data records in D:\Newschd\Schd.dbf.

If the structrures are similar, that is, if the field names are the same and the data types are the same with precision the same or greater in the new file then:

use D:\Newschd\Schd.dbf exclusive
zap
append from D:\Schedule\Schd.dbf

If the structures are not similar then you have to run through D:\Schedule\Schd.dbf using something like scan...endscan and manually insert the records into D:\Newschd\Schd.dbf (after zapping it). With this technique, you could perform any transformations you need to on the old data to make it conform to the new structure.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform