Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into temporary cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00492135
Message ID:
00492172
Views:
20
Glad I could help.

By the way, if you want to make a "writable" cursor (and therefore not worry about unique file names) you can do the following:

SELECT INTO CURSOR mycursor
LOCAL laFields[1]
=AFIELDS(laFields)
CREATE CURSOR writable FROM ARRAY laFields
APPEND FROM DBF("mycursor")
USE IN mycursor &&Close and erase

Of course, this assumes that the original SELECT truly *did* create a temporary file and that it wasn't just a filtered view of the original table (i.e. a fully-optimized query).

Best...

--Brad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform