Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving a view into table .dbf
Message
De
14/11/1997 10:27:04
 
 
À
14/11/1997 10:18:18
Anderson Girardi
Athenas Automação de Escritório
Porto Alegre, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00060255
Message ID:
00060258
Vues:
22
>Hello all
>
>Anyone knows how can i save the results of a remote view into table, by sample mytable.dbf
>
>
>Thanks
>
>
>Anderson Reis Girardi

If you want to create new table:
Select rview1
COPY TO myttable.dbf
If table with identical structure already exists:
Select rview1
COPY TO ARRAY aTemp && can be limited by size of array
Insert Into mytable From Array aTemp
If table with dissimilar structure already exists:
Select rview1
SCAN
Insert into mytable Values(rview1.field1,....)
ENDSCAN
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform