Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving contents of a view
Message
De
21/01/2004 08:10:28
 
 
À
20/01/2004 17:05:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00868642
Message ID:
00868925
Vues:
16
My apalogies, DBF cannot be used there. You could use...
SELECT originaltable
COPY STRUCTURE TO temp
ALTER TABLE temp ADD COLUMN newfield c(20)
APPEND FROM originaltable
You could also scan through the original table if you would want to write data to the newly added fields on a record by record basis.
SELECT originaltable
SCAN
    INSERT INTO temp(field1, field2, field3, newfield) ;
       VALUES(originaltable.field1, originaltable.field2, ;
              originaltable.field3, newvalue)
ENDSCAN
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform