Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Program is running slow - need advice for optimizing
Message
De
08/07/2004 04:33:45
 
 
À
08/07/2004 04:23:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00921850
Message ID:
00921877
Vues:
22
Try this:
SELECT 1
USE ss
DO WHILE .t.
m.a=name
m.a1=p_o_box
m.a2=Postal_cod
m.a3=degree
SKIP
m.aa=name
m.aa1=p_o_box
m.aa2=postal_cod
m.aa3=degree
SKIP
INSERT INTO NEWALL (name, p_o_box, postalcod, degree, name1, p_o_box1, postalcod1, degree1, name2, p_o_box2, postalcod2, degree2) VALUES (m.a, m.a1, m.a2, m.a3, m.aa, m.aa1, m.aa2, m.aa3, ss.name, ss.p_o_box, ss.postal_cod, ss.degree)
select 1
*browse
if .not. eof()
skip 
else
exit
endif
ENDDO
>hello,
>thank you for reply,and advice
>
>it works,but i need to insert the 3 record to one record at newall.
>
>thank you.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform