>1. Jim, I DID use the NOFILTER clause, and had the same problem. Not surprising, since the original SELECT had a concatenated field as one of its fields.
>
>2. Vlad, used( dbf() ) gave FALSE, used( cursorname ) gave TRUE. The cursor was there when I used Disp Stat, but it couldn't be seen with file() or in the Explorer.
>
>3. Tom, this was a file I created with SELECT... to cursor..., not a VFP internal file (really don't care if those are kept in memory). If you also saw this, at least I'm not going crazy.
>
>Thanks, everyone
>Barbara
>
>>Barbara,
>>
>>*IF* you created the cursor in question through an SQL statement, then the NOFILTER sub-clause of the INTO clause should put it to disk for sure.
>>
>>regards,
>>Jim N
>>
>> >>I have a cursor (VFP50a, Win95) which has a filename assigned, which can be read with dbf(). However, the file does NOT exist in the temp file.
>>>
>>>How do you know the file is not there? I mean: how did you verify that?
>>>
>>>> I've checked that the temp directory DOES exist, and that the cursor exists - I can browse it. However, I can't access it with the filename.
>>>
>>>Does that means that USE (DBF()) will give an error?
>>>
>>>Vlad
Barbra
Try a "where .T. " and the rest of your statement. This will turn off some feateures & you may get some better results.
I think I have a Tip I wrote somewhere around here that explains it.
HTH,
Tom