How do I display data from Sql query?

[Biagio_Prisco]

Hi, I need to display the data from an Sql query on one screen. There are 13/14 lines each consisting of 7 fields. What could be the best way to view them?
Thank you

[SteveJG]

It depends in how your SQL query arrives.

If it is a csv, you could use a Dynamic Table using html.

You could use a simple Label, separating each line using a control character ( \n )

You could post all this in a ListView after you parse the SQL response to a List

[Biagio_Prisco]

Thanks for your tip Steve.
I had thought of using a ListView, however, they are numeric data and are not stacked well.
I try to see how a Dynamic Table works.
Greetings

[ABG]

Here's a sample using ListViews and a Canvas to scroll:

TinyDB NameSpace Update via Parallel ListViews Scrollable by Canvas

In response to a recent Help post seeking to create line item increment and decrement buttons for a collection of TinyDB entries, here is a way to do it using parallel ListViews and a Canvas for scrolling. This particular sample uses US state names to receive scores in a separate TinydDBNameSpace tdbStateScores; Sample runs: [Capture] [Capture2] (Unfortunately, this app is too complex for the stock AI2 emulator and Companion, so I had to run the Companion on a GenyMotion emulated Android 4.…

[TIMAI2]

Also @Ken 's Tableview extension

[REBORN !] TableView Extension Versions 3&4 (pre nb191) and 5 by @Ken

as the Appybuilder community has been closed, all extensions published there are lost... except of those, who are still available at web.archive.org By accident I found version 3 of the tableview extension on my computer, so I guess it would be ok, if I upload it here into this thread... @Ken meanwhile agreed to provide his extension here. Thank you @Ken. com.kennicholsandroid.TableView.aix (19.4 KB) TableView_v3.aia (21.5 KB) Taifun Trying to push the limits! Snippets, Tut…

(requires data in a csv table format)

[Biagio_Prisco]

I am trying the TableView_v3 and it seems to me that it can be fine. I'm trying to build the csv file from the query output. I just have to solve the problem of holes (when I have no values) that would make the display out of phase.
Thank you all!

[Taifun]

@Biagio_Prisco

I just have to solve the problem of holes (when I have no values) that would make the display out of phase.

usually you get an empty string from the database in case there is no data, which means all rows of a csv table should have the same number of columns...

Taifun