Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Seek Offset
Message
 
To
07/05/2019 15:58:25
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01668410
Message ID:
01668474
Views:
65
>>>I believe Dmitry says there are only 100 rows in this DBF and he says he pulls the whole thing into a cursor.
>>>Solution: REMOVE THE INDEX.
>>>You really don't need an index or indexes on a table that small. FoxPro will suck the whole table into memory in a heartbeat or two.
>
>Fair enough for a tiny table... though instinctively it's a shame to do away with some of VFP's secret strengths including SEEK() and SET RELATION. ;-)
>
>My pick is that some of the VFP innards date from a time when file access was a yes/no phenomenon so once you get your Yes, you don't want to have to keep checking the obvious when you're after performance. Then OSs and virus scanners etc got clever and began finessing things and every so often somebody fails to Give Way.

In his initial post, Dmitry wrote that the DBF is included in the exe, and later he realized that no index file is used or associated with the DBF. And, the exe is installed and accessed on the network.
I think Chen's SetFilePointer API example is closer to the truth in this case, however, I also think that the the error has to do with the loading of the targeted chunk of the exe. It would not surprise me to eventually realize that the error occurs randomly (and not only when accessing the meta dbf), and that it is caused by micro-drops in network connectivity.
*
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform