View Single Post
  #9 (permalink)  
Old 09-24-2008, 05:27 PM
HenryG HenryG is offline
Junior Member
 
Join Date: Aug 2008
Posts: 14
Default Possible solution

If this error occurs while collecting a table, it may be because some tables have not been created.

Try clicking on the Pause Player Icon on the bottom row. If you haven't used the pause function before, I believe that error
Quote:
"Invalid SQL statement expected -'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE' Error - 2147217900"
comes from closing out the table. The program checks for these tables and that message pops up when it finds that those Pause Tables have not yet been created. Should correct this in the next update. But for now, just click on the Pause Player Icon on the bottom row. That should create those missing tables and that message should go away. It's just a harmless error message.

Someone else reported this and was able to track it down here using their database files. Should be fixed in 2.2.19.
This update will fix that reported problem. I believe your problem may be the same. But let me know.

http://www.definitivesynergy.com/doc.../UpdateBBS.exe

Last edited by HenryG : 09-24-2008 at 07:47 PM.
Reply With Quote