>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