Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy table line by line
Message
De
30/10/2003 13:01:32
 
 
À
30/10/2003 12:13:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00844577
Message ID:
00844617
Vues:
20
>I have two table
>
>TABLE A
>-------
>ident int
>name c
>
>and
>
>TABLE B
>-------
>ident int
>name c
>
>
>so my code is like that
>
>select * from table_a where ident > 10 into cursor cur_temp
>
>
>
>
>and after that i want to copy line by line into table b
>
>how can i do that ????

If you are using VFP 8 you can use the new
INSERT INTO table_b (ident , name) ;
   SELECT indent, name FROM table_a WHERE ident > 10
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform