Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select without Nofilter is Nofilter
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01577987
Message ID:
01577988
Views:
80
>
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
Previous
Reply
Map
View

Click here to load this message in the networking platform