General information
Title:
Select into cursor nofilter option
VFP 7 doc states the following
"Include NOFILTER to create a cursor that can be used in subsequent queries. In previous versions of Visual FoxPro, it was necessary to include an extra constant or expression as a filter to create a cursor that could be used in subsequent queries. For example, adding a logical true as a filter expression created a query that could be used in subsequent queries:
SELECT *, .T. FROM customers INTO CURSOR myquery
Including NOFILTER can reduce query performance because a temporary table is created on disk. The temporary table is deleted from disk when the cursor is closed. "
But it never seemed to be problem( at least in VFP6 ) and it is not a problem in VFP7 for
SELECT * FROM customers INTO CURSOR myquery
select * from myquery where cust_id = some_id into cursor myquery1
What is meant by "subsequent query" then ?
Thank you
Michael
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