My database has about 10 tables, all not very big but with already several hundred rows. Until now everything worked fine and I was surprised that only very few lines of code had always a great effect. I got a lot of functionality in a short time. But now I came to another part of my application where I use a code sequence like this:
Code: Select all
select << "select * from TR;";
(I want to use a RecordSet later.) But I don't get this working because select.execute() always throws an exception of type Poco::NotFoundException. The message text of this exception is just "Not found". I have no idea about the reason of this exception or the location of the throw. The table exists. The table has at least one record. The table has a primary key. I can execute exactly the same select using sqlite3 and there it's successful. I can insert, update or delete in the table very well using my own application. Why can't I select?
I tried to select other tables here. I detected that one table works, all others do not. Why? This is very obscure.
Should I really install the sources to debug this?
My SQLite is 3.5.7. Do I need a newer one for POCO 1.3.5?