[SQLite] Read the only Row of a RowSet?

Databases
1

In a SQLite Database, I have a service TABLE with only one Row.

The LR provided example shows how to read all entries of a RecordSet, but how do I read the only Row of that TABLE ?

2 
Var row As RowSet = db.SelectSQL("SELECT * FROM service WHERE rowid = 1")

If row <> Nil

  MessageBox(row.Column("Name").StringValue)

End If
3

Thank you Martin.

I was not searching there !

4

Works fine… after (late) dinner !