How do you format Sqlite outputs

[Ewelme Webmaster]

The Taifun sqlite extension works brilliantly but I'm struggling with outputting data in a suitable format.

Searching the internet I see that there is a "(.)mode" option when using sqlite in a Command Line i.e. dot commands.

Is there anything similar when using sql inputs to the extension?

I looking for a way to output text in tabular form.

Thanks

Dave.

[Taifun]

the sqlite extension returns the result as csv table

use the list from csv table block to convert it into a list of lists

to display there are several possibilities, for example 

Dynamic table layout with any number of rows and columns including table listpicker

Taifun

---

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 

[Ewelme Webmaster]

Great !

I'll check that out as soon as possible

Dave