General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only