Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xbase commands Vrs Sql commands
Message
From
08/05/2005 06:16:16
 
 
To
07/05/2005 11:39:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01011885
Message ID:
01011998
Views:
16
>I would imagine this:
>SELECT * FROM mytable INTO CURSOR mycursor

>would be faster than:

>create cursor mycursor (field definitions)
>select mytable
>scan
> scatter memvar memo
> insert into myCursor from memvar
>endscan

SELECT * FROM mytable INTO CURSOR mycursor
append from ()

might be a better comparison...

regds

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform