Retrieving SQLite DB data in TextFields

Getting Started
1

Hello,
I’d like to get all different data from a SQLite DB and put them into single TextFields instead of using a ListBox.
Can it be done and, in case, how?

Thank you

2

What does this mean?

3

I mean, I’m building an automobile database holding different data(license plate, date of sticker, periodic revisions, etc.). I’d like to put all those different data into single fields, each named after the data it is supposed to hold. These fields are spread into different areas of the window. I’d like to avoid, if possible, the use of a ListBox to collect data.
I know how to get data from a DB and use AddRow to put them into a ListBox, I wonder if it is possible to do the same with single fields.
I hope I clarified what I mean

4

start with the dbkit in the xojo examples / database folder
then try the “separate” window button and adapt to your project

1 Like
5

You mean something like:

Var  reg as RowSet, dbh as SQLiteDatabase, id as Integer

id  = 27
reg = dbh.SelectSQL ("select firstname, lastname from licencedata where id = ?", id)

firstnameField.Text = reg.Column("firstname").StringValue
lastnameField.Text  = reg.Column("lastname").StringValue
6

Thank, it should be it.
I’ll test it and see what happens (fingers crossed).