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