Thanks Cindy

I always forget that command its so unintuative.
I usually end up trying to use FORCE for force disk presence geddit:)
this of course does something completely different



>>This problem is usually caused by there not being a disk presence of the file involved.
>>
>>VFP is just keeping the whole file in memory and lying to you with the DBF() command.
>>
>>I think it is possible to force a disk presence somehow but I cant remember off hand.
>
>Mark - you're thinking of the NOFILTER keyword of the SELECT SQL statement.
>
>
>>
>>when you do your select make sure you specify that the output is going to a table and the problem will go away.
>>
>>The reason it goes away when you change SET DELETED is likly to be because you are increasing the amount of records being stored.
>>
>>When VFP sees enough records for it to be worth while creating a disk presence then it will create a file.
>>
>>>Hi,
>>> I have a problem of update cursor.
>>> I have issue USE DBF("mycursr") AGAIN SHARED, it work in my pc however i get error "c:\....\xxxx.tmp doexn't exist" in my colleague's pc. After couple of trying, I found that it only work in my colleague's pc if SET DELETED OFF.
>>> Any idea?
>>>
>>>Thank you