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:
00389585
Vues:
13
>Hi Larry:
>
>D:\Newschd\Schd.dbf has all of my new addtional fields.
>
>D:\Schedule\Schd.dbf has all of my live data records.
>
>I would like to move all Schedule\Schd.dbf records into D:\Newschd\Schd.dbf table. Will scan work for this also?

Yes you can brute force it. Scan table1, seek on table2, if exist, replace values if needed. If it doesn't exist, insert a new record.

Note: Make sure the new fields allow NULL values or have default values assigned. If you attempt to add a new record from table1. the table2 fields without values will throw an error, otherwise.
Larry Miller
MCSD
LWMiller3@verizon.net

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

Click here to load this message in the networking platform