General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only