Android Question SQLite b4a

[Hirogens]

Hello I would like to create a Local Data Base with SQLite. I need to create a single table with a lot of fields for the user informations. I had seen the tutorial by Klaus and I choose the 1st one: Simple ADD, Delete, Update. Now my big question is: It's better to put the code in a new Service (call SQLite) or to put everything in the Service (Starter) ? Or maybe create a class with all the function.

Thanks =)

 

[Alexander Stolte]

I think a class is better, then you can call it from everywhere and you keep your code smaller in other modules. My opinion

 

[LucaMs]

DB declaration and initialization in the Starter, then a class to work on it, passing it to the class initialization.

 

[MarkusR]

you can design the db with "DB Browser for SQLite"
in the asset folder you not have access, to you need to copy it once for using in your app to a better folder.
then a class to handling the data,search/insert/update/tableview

 

[Hirogens]

Thank you everyone =)