Table not found error after SQLite Database update

[cyclechris]

Hi,

I've kludged together an app that was querying a database, then clicking on one of the listings would display more in depth information on the one clicked. It was working great until I decided to normalize the main table "channels" a little more to add yet another layer of "drill down" to details in the program.

I made a new table adjusted my Query code in the application and everything fired up nicely, until I reached the point where I was hitting the new table. It said No such table, although there IS such a table.

I copied the failing Query and tried it in the database and it worked fine. I tried flushing user data (in the emulator) with no luck. I rebuilt the new table from scratch, thinking that doing a table copy/paste in the DBMS maybe hosed something up. I even copied the database to a differently named database and tried, no joy.


I am running B4A 2.50

 

[cyclechris]

Solved - sort of, I still don't understand...

So I still don't know what I did, or why after changing the structure of the database, nothing I did would make it update in the program. However, I was able to make it work again. I saved the layout files, database, images I used etc. Then I made a whole new project. I cut and pasted my old Activity module code into the new project, added a code module and cut/pasted the DBUtils code I was using. Then I added a couple libraries and recompiled and it worked again.

:sign0163:

It was like the database was in a non-clearable cache or something.