Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sime Atanasov

    Foxpro and MySQL: Server has gone away

    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...
  2. Sime Atanasov

    Foxpro and MySQL: Server has gone away

    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)...
  3. Sime Atanasov

    Test if program is running

    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?
  4. Sime Atanasov

    Test if program is running

    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. ***********************************************************************************...
  5. Sime Atanasov

    XFRX - Are newer versions any faster...

    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...
  6. Sime Atanasov

    Foxpro and MySQL: Server has gone away

    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...

Part and Inventory Search

Back
Top