TheFirstName Varchar2(15);
TheLastName Varchar2(15);
TheId Number;
TheIdValue = 550
SELECT Id, FirstName, LastName
INTO TheId, TheFirstName, TheLastName
FROM MyTable
WHERE Id = TheIdValue;
I have not used the DBUitils, but do the following
Dim oConnect as Sql
Dim oRecordSet as Cursor
Dim cQuery as String
Dim cLastName as String
cQuery = "Select Id, FirstName,Lastname From MyTable Where Id = " & TheIdValue
'Think Sqlite has an 'AS' Clause so you can try this
cQuery = "Select Id, FirstName as TheFirstname,Lastname as theLastName From MyTable Where Id = " & TheIdValue
'Database should not have NULL Values but in case they do
cQuery = "Select Id, IfNull(FirstName,'') as TheFirstname,IfNull(Lastname,'') as theLastName From MyTable Where Id = " & TheIdValue
oConnect.Initialize("yourdir","yourdb",False)
oRecordSet = oConnect.ExecQuery(cQuery)
If oRecordSet.RowCount > 0 Then
oRecordSet.Position = 0
cLastName = oRecordSet.Get("YourColomnName")
End If
HTH