Android Question Application keep using old database

[EvilCarrot]

Hello,
I've updated the database my application is using, including editing one columng name- let's say I've changed it from "Users" to "Clients".
However, when I'm debugging the app using B4A Bridge it keep acts like it was using the old DB. When I want to select all the rows where "Clients='xxx'' it returns 0 of them, but when I change it back for the old name ("Users='xxx'") it works just fine. I've tried rebooting the phone, changing DB name and deleting the old database from the files folder and the files tab. Does anybody know how I can deal with this problem?

 

[klaus]

You need to give more information on what you have done.
How do you initialize the batabase ?
Where is your databse ?
How do you update it ?
etc.

 

[EvilCarrot]

Ok, sorry
I initialize it in "Sub Activity_Create(FirstTime As Boolean)" using this code:

File.Copy(File.DirAssets,"db.sqlite",File.DirInternal,"db.sqlite")
SQL.Initialize(File.DirInternal, "db.sqlite", False)

As you can see in the code, it is stored inside the app
I've updated it by just changing the file in "Files" folder, however I plan it to update it remotly from the server after the app will be published

 

[Mahares]

Try to add the database file to the files tab of the IDE by clicking the 'Add File' instead of simply putting the database file in the files folder.

 

[EvilCarrot]

Done that too, sorry, forgot to mention it.
I've also try adding new db under new name both in the folder and files tab with deleting the old database from both files tab and files folder.

 

[klaus]

Sounds strange. It should work.
Can you post your project, so we could test it ?

 

[klaus]

In your database file systemowe5.sqlite in column Uklad there is no 'Czaszka' but 'Kosci'.

 

[EvilCarrot]

Looks like I made a mistake when working in SQLite Studio and I was looking for the couse in B4A. Sorry for wasting your time for such a stupid thing and thank you for pointing out my embarrassing mistake!