Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from two tables into a cursor
Message
De
24/09/2007 18:19:42
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01256480
Message ID:
01256513
Vues:
15
>The two tables have almost the same structure, but one of the
>the tables may have one field or two more
>(VFP 9)

If you want to retain the extra fields you can
SELECT * FROM tableWithExtraFields INTO CURSOR newCursor
APPEND FROM tableWithMissingFields
The extra fields will be filled with the default value for that data type.

If you want only the common fields you can
SELECT * FROM tableWithMissingFields INTO CURSOR newCursor
APPEND FROM tableWithExtraFields
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform