Android Question List add multiple columns

[padvou]

Hello,
I have an sql query that returns 4 columns.
How can i add the data to a list so that each row in the list is a record from the result of the query but the list will also reflect the 4 columns?

 

[LucaMs]

Registered since 2012 and still not able to use the site's search function?

These are topics discussed 1,000 times!

Sorry but, personally, I refuse to answer in a case like this.
(and maybe today I'm a little too nervous)

 

[TILogistic]

Sorry but, personally, I refuse to answer in a case like this.
(and maybe today I'm a little too nervous)

Is it because of the earthquake in Turkey and Greece?

?????

 

[stevel05]

Define a Type, create an instance for each row add it to the list. You can then easily sort the data on any column using the List SortType Methods.

 

[Brian Dean]

How can i add the data to a list so that each row in the list is a record from the result

You create a Type, like this ...

Type sectionRec (id As Int, title As String, row As Int)

Then you transfer the data from each SQL record to a new object like this ...

Public Sub getSections(pageId As Int) As List
    Dim cur As ResultSet
    Dim result As List
    result.Initialize
    cur = dB.ExecQuery(SQL_SELECT_SECTIONS & pageId & " ORDER BY Row")
    Do While cur.NextRow
        Dim s As sectionRec
        s.Initialize
        s.Id = cur.GetInt2(0)
        s.title = cur.GetString2(1)
        s.row = cur.GetInt2(2)
        result.Add(s)
    Loop
    Return result
End Sub

I hope that helps.

 

[klaus]

DBUtils2.ExecuteMemoryTable (SQL As SQL, Query As String, StringArgs As String, Limit As Int)
Executes the query and returns the result as a list of arrays.
Each item in the list is a strings array.
StringArgs - Values to replace question marks in the query. Pass Null if not needed.
Limit - Limits the results. Pass 0 for all results.
Returns : List

 

[TILogistic]

DBUtils2 It is designed to work with SQLite databases.

 

[udg]

Another option could be a LOM (list of maps). Each record is returned in a map (key = field; value = data) and each map is added to a list.

 

[TILogistic]

Another option could be a LOM (list of maps). Each record is returned in a map (key = field; value = data) and each map is added to a list.

See:
DBUtils2.ExecuteMap(SQL As SQL, Query As String, StringArgs As String)

'Executes the query and returns a Map with the column names as the keys
'and the first record values As the entries values.
'The keys are lower cased.
'Returns an uninitialized map if there are no results.

 

[klaus]

I think that we need to wait for more information from padvou.

 

[amykonio]

DBUtils2 It is designed to work with SQLite databases.

Yes. But this doesn't mean it won't work with jdbc. I use DBUtils2 with sap ase and sql anywhere. Had no problem in the past.

Andreas.

 

[LucaMs]

Is it because of the earthquake in Turkey and Greece?

?????

No, the annual earthquake period is starting. I was not surprised and there will be one of at least 6.5 degrees in Italy within 15 days maximum.

 

[ddefrain]

Hello,
I have an sql query that returns 4 columns.
How can i add the data to a list so that each row in the list is a record from the result of the query but the list will also reflect the 4 columns?

How about this one?
Cards

...or
B4xTable