E EvilCarrot New Member Licensed User Longtime User Aug 24, 2015 #1 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?
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 Expert Licensed User Longtime User Aug 24, 2015 #2 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. Upvote 0
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.
E EvilCarrot New Member Licensed User Longtime User Aug 24, 2015 #3 Ok, sorry I initialize it in "Sub Activity_Create(FirstTime As Boolean)" using this code: Code: Copy 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 Upvote 0
Ok, sorry I initialize it in "Sub Activity_Create(FirstTime As Boolean)" using this code: Code: Copy 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
M Mahares Expert Licensed User Longtime User Aug 24, 2015 #4 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. Upvote 0
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.
E EvilCarrot New Member Licensed User Longtime User Aug 24, 2015 #5 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. Upvote 0
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 Expert Licensed User Longtime User Aug 24, 2015 #6 Sounds strange. It should work. Can you post your project, so we could test it ? Upvote 0
klaus Expert Licensed User Longtime User Aug 24, 2015 #7 In your database file systemowe5.sqlite in column Uklad there is no 'Czaszka' but 'Kosci'. Upvote 0
E EvilCarrot New Member Licensed User Longtime User Aug 24, 2015 #8 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! Upvote 0
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!
