Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Program is running slow - need advice for optimizing
Message
From
08/07/2004 04:33:45
 
 
To
08/07/2004 04:23:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00921850
Message ID:
00921877
Views:
23
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform