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
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
Last edited: