I’ve been breaking my head over this one but i think there should be a simple solution i’m overlooking…
On a page i have a table and a button, by pressing the button i call on a script which empties the table using
Headers= ["Header1: "," Header2"]
blankdataset = 
table.data = system.dataset.toDataSet(Headers,blankdataset)
Then, using a for loop and “system.db.runQuery” i call on an SQL query to fetch some data which gets imported to the table using the
table.data = system.dataset.addRow(table.data, Row)
The challenge i am facing is that doing this makes all the columntypes in “String” format while the data i am fetching is a mix of integer,strings and dates and i would like to be able to (for instance…) change rowbackground color based on one of the columns.
Does anyone knows of a solution and/or script command to change the columntype?
- Edit: forgot to mention i am using multipple for loops to get data from different tables in the database, this is the main reason i am creating a complete row and adding that to the table…