Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update cursor!!
Message
From
18/12/2000 18:15:14
 
 
To
18/12/2000 16:27:31
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00454668
Message ID:
00454859
Views:
26
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
Previous
Reply
Map
View

Click here to load this message in the networking platform