B4J Question B4j Code Modules and reusable code

[JaunLukePicard]

I am continuing development of a database and have a few separate database files in SQLLite. I want to be able to re-use as much code that handles database functions as possible.

In this case handling things like:
1. Creating a Map that receives the field data from a form and writes the data to the corresponding table.
2. Record and Table re-draw functions
3. Form event processing (Buttons and Fields).

Any ideas please?

 

[billzhan]

Separate ui from logic is the general rule.

I have a little experience on sqlite with B4A and B4J, use dbutils module functions as much as possible.

Queries are different in B4A (cursor) and B4J(resultset), so you have to avoid them, or make them based on dbutils functions.