'database' and 'MUI.table'

[Stephan Stadler]

I find samples for working with 'database', I also find samples for working with 'MUI.table'.
But I do not succeed in joining both topics.

I'm looking for a small solution to show all "firstnames, lastnames, adresses" in a database in that MUI.table and to add an new contact/adress to table and database.
Does anybody know a sample, I can learn about this?

Thank you!

[Alan Hendry]

HI,
Starting with the database sample (typing this in here, so there may be typos etc)
Change the database table create for your fields
        "(id integer primary key, firstname text, lastname text, address text)" )  

At the beginning of function OnResult( results ) create the table but with no data

        var headers = ["ID", "FirstName", "LastName", "Address"]
        var table = MUI.CreateDataTable(headers, "", 0.96, 0.6)
        lay.AddChild(table)

Put each row in the table

      for (var i = 0; i < results.rows.length; i++ ) {  

        var item = results.rows.item(i)  
        table.AppendRow(item.id + ": " + item.firstname + ": " + item.lastname + ": " + item.address)
     }  

(remove everything for field txt)

 Regards, ah

[Stephan Stadler]

That doesn't work any more.
I get the following message:

• Script Error: AppendRow is not defined, Line 1, undefined

what's going wrong???

[Right2TheV0id]

When you'll get your invitation to the premium forum you should look at this post:

https://groups.google.com/g/droidscriptpremium/c/VE1rDMMND8M/m/88MWHVgDCAAJ

[Jumar]

I just want to paste it here since some users get MUI from PlayStore

You need to make sure that the Table control is fully loaded before calling any methods that will update the data such as AppendRow, SetRows, RemoveRows and the likes.

Try this

cfg.Light

cfg.MUI

function OnStart()

{

    lay = MUI.CreateLayout("Linear", "FillXY,VCenter")

    

    var values1 = [ "John:24:deepPurple", "Jane:22:deepPurple", "Jonathan:26:deepPurple" ]

        

    var values2 = [ "Doe:12:deepPurple", "Dawn:20:deepPurple", "Dane:16:deepPurple" ]

    table = MUI.CreateDataTable("Name,Age,Color",values1, 1, 0.4, 'selectable')

    lay.AddChild(table);

    

    setTimeout(function() {

        table.SetRows(values2)

    }, 2000)

    

    app.AddLayout(lay)

}

Regards

Jumar

[Stephan Stadler]

Hey, that works!!!
Thanx to Jumar. Well done.
I would never find out by myself.

Problem solved!

[Right2TheV0id]

There is now a table.SetOnReady() method, but it is not present in the built-in documentation.

You can check the online documentation, which is more up to date:

https://symdstools.github.io/Docs/docs/MUI/CreateDataTable.htm