B4J Question SPinner write a value taken from database

[ivanomonti]

how do you populate this code object?

I ask for patience and forgive me, but I've never used it and I can't find reference

 

[LucaMs]

Databases have nothing to do with your question.
https://www.b4x.com/android/forum/threads/b4j-scrivere-da-codice-come-in-textfiel.116691/post-729222

 

[ivanomonti]

Databases have nothing to do with your question.
https://www.b4x.com/android/forum/threads/b4j-scrivere-da-codice-come-in-textfiel.116691/post-729222
View attachment 92375

maybe I was not clear in writing it, I have a data stored and I have to publish it in a spinner, the data is read by database and written by the usual recorset or list

Log(SPHour.Value) = ok

SPMinutes.???=ls.Get(4) 'ls = list

 

[LucaMs]

When you know that Spinner requires a List, you have to look for how to get a list of data by reading data from a database. Search for one of the many examples about this.

 

[ivanomonti]

When you know that Spinner requires a List, you have to look for how to get a list of data by reading data from a database. Search for one of the many examples about this.

explains

 

[LucaMs]

???

First, I know that you are referring to a local (PC) SQLite and B4J; you should have specified it.
Second, what is your question? How to fill a Spinner OR how to retrieve data from a DB? To fill a Spinner you have to pass a List of strings to it; how to fill a List from a DB?

by reading data from a database. Search for one of the many examples about this.

' Here declare and open SQL1 Sqlite DB

Dim lstTexts As List
lstTexts.Initialize

Dim Cursor As ResultSet
Cursor = SQL1.ExecQuery("SELECT YourFieldName FROM YourTableName")
Do While Cursor.NextRow
    lstTexts.Add(Cursor.GetString(YourFieldName))
Loop
Cursor.Close

Spinner1.SetListItems(lstTexts)

It's enough?

I know that you... know how to use a DB, since you have already asked in recent days how to save a bitmap in a Blob field and you have solved it, so I don't understand what is the problem now.