B4J Question SQL Query - Detect if value is not in database

UserCheck = LoadSQL.ExecQuerySingleResult("SELECT COUNT(*) AS User_Exists FROM users WHERE ClientName='John'")

If UserCheck = 0 Then Value = "No such user"

UserCheck = LoadSQL.ExecQuerySingleResult("SELECT count(*) FROM users where series ClientName = '" & Value & "'")
[\code]

but you may well have to tweak to suit your environment / App

Sub getClientName(name As String) As String
    Dim result As String = "Not in Database"
    Dim cursor As ResultSet
    Try
        cursor = gSQL.ExecQuery2("SELECT ClientName FROM users WHERE ClientName=?",Array As String(name))
        Do While cursor.NextRow
            result = cursor.GetString2(0)       
        Loop
    Catch
        Log(LastException.Message)
    End Try
    Return result
End Sub

Dim Value as String = "John"
Dim UserLastName as String
UserCheck = LoadSQL.ExecQuerySingleResult("SELECT count(*) FROM users WHERE ClientName = '" & Value & "'")
If UserCheck = 0 Then
      Log("User is Not in database")
   Else
      Log("User is in database")
      Dim Value asString
      UserLastName = LoadSQL.ExecQuerySingleResult("SELECT Surname FROM users WHERE ClientName = '" & Value & "'")
      Log(UserLastName)
End If

Dim Value as String
Dim UserLastName as String = LoadSQL.ExecQuerySingleResult("SELECT Surname FROM users WHERE ClientName = '" & Value & "'")
if UserLastName != Null Then
    Log(UserLastName)
else
    Log(Value & " is Not in database")
end if