>
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
I'm not sure what you mean by NOFILTER ...but does this help??
When SET FULLPATH is ON, DBF( ) returns the path to the table with the table name.
When SET FULLPATH is OFF, DBF( ) returns the drive on which the table resides with the table name
SET PATH and your windows environment settings might play a part in this too (where the temp files are created when doing INTO CURSOR.)
ICQ 10556 (ya), 254117