Looking at my notes when I encountered those issues, it was splitting the query in two, which helped me with the "server has gone away" error.
Extending the buffer fixed a long operation (like deleting 500k records in one shot) with an inefficient index.
Two issues from about the same time...
Jay,
Apologies for the late reply - hectic few days here.
If you still find this relevant, I retrieved my notes (actually screenshots) from September '21 on a similar problem I had.
I believe playing with the buffer size and stuff like that helped me execute commands (delete in my case)...
Sure, it can run on as many machines as you want (on a network location or their separate copies on the local drives), files shared, handshaking and all that. It just doesn't allow it to run twice from the same PC/workstations - which is what you want, right?
Hi SitesMasstec.
1) Chris' solution is great. 2) The code bellow works well too, and 3) you can always low-level read the tasks from the Windows Task Manager and determine if the exe is already running.
***********************************************************************************...
Hi Griff.
Aside from the fact the data is going through an excel format, my experience has been that Bullzip (or any other) pdf driver works reasonably fast. As Tom and Chriss have mentioned it too.
For more than ten years, once a month my program would send around 700 emails, each with 3 PDF...
Hi Jay.
I've done quite a few MySQL connections and SELECT commands from VFP and most of the times it works fine.
The instances I've had something like losing the connection to the MySQL server (table) while doing a query, even a simple one, is when there are many records pulled. And, I've...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.