Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP5 OLE DLL - Selects into cursor
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00036835
Message ID:
00036840
Views:
33
>In VFP5.0a, I compiled an OLE DLL with 2 selects. The first selects from an indexed table of 300,000 records into a cursor. The select is fast. I then need to select from the cursor. I get an error saying the cursor I am selecting from must be created with "SELECT... INTO TABLE". This is good and everything, but selecting from the original table into a file, greatly decreases the speed because now it has to write the resulting file physically to a table where before it was just a subset of the larger table. Has anyone been able to get around this and not lose any speed?
>
>TIA,
>
>Garritt

combine the select statements?
Previous
Reply
Map
View

Click here to load this message in the networking platform