Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO plus APPEND FROM or SELECT - SQL ?
Message
 
To
27/10/2003 17:48:46
Mark Alexander
Alexander & Associates
Fort Smith, Arkansas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: COPY TO plus APPEND FROM or SELECT - SQL ?
Miscellaneous
Thread ID:
00843185
Message ID:
00844038
Views:
29
Hi Mark,

I tried this and it was about 0.4s faster than the current code. That is using SCATTER MEMVAR and INSERT FROM MEMVAR, using a direct INSERT INTO with the fields name wasn't faster.

I ended up still using the COPY TO WHILE but using INSERT INTO SELECT instead of APPEND FROM. This was 0.5s faster than the current code.

Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform