I get an error window saying Debugprogram.exe has stopped working whenever I run SQLSelect or Prepared SQL Statement. I am new to XoJo but nothing comes up in the Run window so I am having a hard time understanding where the error is coming in. I am using Windows 7 Pro and a MySQL database.
Any ideas? Is there a separate way to debug that I am missing?
It could mean any number of things. I’d guess it might be an infinite loop. Put a breakpoint just before the SQLSelect and then step through the code to figure out where it stops responding.
Are you closing your connection after every query?
If so you could have encountered this bug:
43358 (Database Plugins) MySQL Plugin crashes when closing the database.
…which, ahem, might be fixed in an upcoming version.