Android Question Recorddata mapping with SQL

[epiCode]

Why do we need to define recorddata in code when SQL query can anyways return not just the data but field type.
There seems to be so much of duplication of efforts like

1. defining data in sql ,
2. creating a query with all those fields
3. then in class_global as type,
4. then map resultset to record data using getstring

why can we not have a simple recordset which is formed using the sql query itself?

its easy for 4-5 fields in examples but gets very complicated with larger database. One I am working on has 116 fields.

 

[TILogistic]

look, if you use SQLite.

if not, adapt it to your database.

[B4X] DBUtils 2

DBUtils is a b4xlib with useful utilities related to the SQL library. It is designed to work with SQLite databases. There have been three versions of DBUtils, one for each platform (except of B4R). DBUtils v2.0 merges the three modules to a single module that is compatible with B4A, B4i and...

www.b4x.com

DBUtils Example

Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ This example demonstrates how DBUtils module can be used in B4J. DBUtils was modified to match the slightly different API of B4J jSQL library. Other changes: - ExecuteSpinner and ExecuteListView were...

www.b4x.com