Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bizarre temp file problem
Message
From
21/12/1999 20:04:16
 
 
To
21/12/1999 18:33:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00306991
Message ID:
00307043
Views:
29
>>In addition to what Craig said, you can use the NOFILTER clause to force the creation of the cursor on the drive.
>
>But DBF() would return the name of the table in that case, not a tempory file path (and she said she'd tried NOFILTER).

She tried NOFILTER, but not necessarily with the SUSPEND in place, since she got the same error with and without NOFILTER. NOFILTER only has an effect if the result of a query is fully optimizable and results in a filtered view of the table, in which case DBF() returns the base table name, and things like RECCOUNT() are not accurate.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform