Have a look at Daniel's response - I liked that example.

Thanks anyway

Will

>Hi all,
>
>It seems this is one off VFPs optimizing mechanism. A while ago while I assumed that every temp file is written to disk, CraigB told me it seems not to be always the case.
>
>In certain circumstances (maybe it has to do with the size of the cursor) the temp cursor might not be written to disk, but held in chache memory (Either VFPs chache or the OS). In these circumstances you'll find that though the DBF() is returning a Temp filename, the FILE(DBF()) function is returning .F.
>
>Walter,
>
>
>
>
>>I seem to be coming up with some strange things today...
>>
>>I have a select statement with a Nofilter command in it
>>
>>

>>Select ;
>>	prod_cd , ;
>>	Alltrim(Str(ean_cd,14,0)) as ean_cd, ;
>>	Alltrim(Str(var_num,2,0)) as var_num, ;
>>	prod_grp, desc ;
>>	FROM cur_prsr ;
>>	ORDER BY prod_cd ;
>>	INTO CURSOR pa_prsrch NOFILTER
>>
>>? File(dbf()) && Returns .F.
>>

>>
>>This creates a cursor with no presence on disk...
>>so I tried adding a Where .T. clause in...
>>Still no luck
>>
>>I even looked with Explorer to see if the File() check was lying
>>
>>I thought this wasn't a problem any more?
>>
>>Win95 VFP6 SP4