A cursor is always created. What you're asking is, what controls the file being created? If there is enough memory, the result will be held completely in memory. If not, VFP creates a temp table.
>
SELECT * FROM mytable WHERE keyvalue = "myvalue" INTO CURSOR myCursor
>? DBF('myCursor')
>
>On my computer I get an unexpected result of: c:\tempfilepath\xxxx.tmp
>
>On a co-workder's computer I get the expected result of: c:\path\mytable.dbf
>
>
>
>Is there some setting or condition which controls whether or not a cursor is created NOFILTER by default?
>
>Thanks to all..........Rich
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer