Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy table line by line
Message
De
30/10/2003 12:47:36
 
 
À
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:
00844608
Vues:
38
Why are you using a temporary table at all? Do you have a need for the middle table? If not, you could:
SELE tablea
Scan ALL FOR tablea.indent > 10
   Insert Into tableb (indent, name) values (tablea.indent, tablea.name)
EndScan
>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 ????
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform