Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add file an .EXE after it is built?
Message
 
 
To
17/04/2019 09:13:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01668100
Message ID:
01668145
Views:
31
>>>It is still odd that this specific file gives you problems. After working with DBF's for 25 years I have not seen something like this happening without a reason. Once I had an issue where a DBF file got corrupted sporadically, and for several years there was a workaround in the application that automatically rebuilt this file when this happened. The true source was never found until I investigated the application and found out a code that under certain circumstances deleted the CDX file of this table. This code was supposed to run only in Developermode, but found its way into production.
>>>
>>>One Question would be what the error is when this file cannot be opened (file corruption or access denied?). An alternative way to have this more resilient could be to change the format to XML or CSV. But I still believe there must be an error that causes the issue in the first place.
>>
>>Actually the error points to the application not being able to read the index file associated with this SDTMeta.
>>And I have rebuilt the index many times but to no avail. Oddly this happens with just one customer. I suspect that some PCs have an issue and it shows in my app. I have seen the same customers sending messages of Error 1104 Error Reading other files. Also, as I checked now, the CDX files.
>
>We have this error periodically as well. We have never been able to identify the cause. It occurs on machines who have one of their local drives mapped and shared to other computers, as well as on dedicated servers.
>
>We have disabled caching on the various machines to work around bugs introduced by local machine caching on a network drive in a multi-user environment. It still happens from time to time (we have a few hundred customers, 95% of which use our apps daily, and 80% of which use them heavily (nonstop) daily).

Thank you for sharing. I am glad I am in a good company :)
I don't have as many customers as you do. But you also used the "we" and I am just "me, myself, and I" :) And I don't have the resources and the time to look into every users' PC or something like this. I try to resolve, if possible, or minimize the issue, by making changes to the application.
One thing I am striving on is to convert all or as many customers as possible to SQL Server database. Right now I have about 50-50 split between VFP and SQL database. SQL data offers fewer issues.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform