[SQLite] Read the only Row of a RowSet?

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 ?

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

If row <> Nil


End If

Thank you Martin.

I was not searching there !

Works fine… after (late) dinner !