Android Question [SOLVED] MSMariaDB/MSMySQL query/bind to CustomView

[Magma]

Hi there...

anyone tried to view results (query-bind) from MSMariaDB to table customview ?

I know that the original version is for sqlite - but i wanna know if someone already change/add code for MSMariaDB or if there is a better free GRID that bind to tableview (MSMARIADB).

Is there an example for MSMARIADB with a GRID/columns/rows...

If someone already did - is it easy to share the code ?

Thanks in advance

 

[DonManfred]

There is no built-in binding in MSMySQL and MSMariaDB.
You can query results and update/create/delete records.
Results from a query are returned as a LIST holding a Map for each Result-Row.

It is up to you to use the Data in a Tableview, a CustomListView, a Listview, a Edit, a Label, whatever...

 

[Magma]

@DonManfred - Thanks for fast answer, yes i know that is no built in binding... but i was curious if someone already make a different verison of customview flexible table.

Every row is a json format (like) - what is the best solution to turn it at fields fast (list) and how (a small example will be helpful) ?

 

[Magma]

Found it ... this example will give from 'i' row the first field...

                Dim fields As Map = data.Get(i)
                Log(fields.GetValueAt(0))

 

[Magma]

Found a solution posted there:

https://www.b4x.com/android/forum/threads/class-flexible-table.30649/page-37