SQL logic error or missing database no such table when deleting from database
Not sure if this will help you, but I ran into a similar problem:'no such table: ***'
In my case it turned out to be the fact that my connection string would specify database as a relative path:
'URI=file: mydatabase.sqlite'
It all worked fine, until I would use an 'OpenFileDialog' inside my application. That changes current directory, and throws off the connection string. A quick fix, is using absolute path for your database inside the connection string:
'URI=file: C:\Test\mydatabase.sqlite'