>Cetin,
>
>
>You might have the c:\temp directory with normal attributes but still get that message.
>
>Could you explain under what circumstances it can happen?
>
>
>The easy solution is to create a table instead (a cursor is always created on disk too - you'd add your own cleanup)
>>PS: Not really seeing it doesn't exist there with explorer doesn't mean it's not created, even the smallest cursor allocates its filename.>
>A VFP cusrsor may not have a physical presence on the disk if it's relatively small because it's file is created with
FILE_ATTRIBUTE_TEMPORARY attribute which tells OS to avoid writing data back to disk if sufficient cache memory is available.
FILE_ATTRIBUTE_TEMPORARY yes but still it's a file. You can't create a file with the same name, dbf() returns a valid name, file() returns .f. etc
It doesn't have a direct relation with its size :
Create Cursor mmm (myField L)
? Dbf('mmm'),File(Dbf('mmm'))
Alter Table mmm add column myField2 L
? Dbf('mmm'),File(Dbf('mmm'))
Pass dbf() to an automation object such as excel with OLEDB or ODBC and you get it doesn't exist.
I don't remember others as I posted years ago, generally worked around with use .. again trick.
Cetin