>>
Mark,
>>Other than some cleanup benefits cursors are "always" written to disk. IMHO take the easy way and select into table.
>>OTOH if you have a DBC open (or create a temp one) you could create-drop a temp view on the fly.
>>Cetin
>
>Cetin,
>I'm actually not looking for the 'easy way'; I want to know what happens and why it doesn't work.
W/o seeing some code my best guess is that you're not selecting into a true cursor. You could make a true cursor :
-Including a dummy nonexistant field in SQL
select *, 1 as myDummy ...
-Including a dummy .t. expression in where
select * rom myTable where .t. [ and ...] ...
Above are also FP2x compliant. In VFP you could also :
-Use "nofilter" clause
select ... nofilter
A sample readwrite cursor :
select * from myTable into cursor crsTemp nofilter
use (dbf("crsTemp")) in 0 again alias "myRW"
use in ("crsTemp")
select myRW
Cetin