Sqlite Help
Posted: Mon Sep 11, 2017 6:01 pm
Hi,
i was wondering if someone could tell me how i can really detect if no records exist or just has only value 'True' in it
i use:
Help please
Thanks
i was wondering if someone could tell me how i can really detect if no records exist or just has only value 'True' in it
i use:
Code: Select all
but it always return 0 even if we have no data in the table :( Dim whereClause As String = "monthid ='" & monthid & "' AND yearid ='" & yearid & "' AND status LIKE '" & Value & "%'"
Dim count As Integer = Convert.ToInt32(DataBase.ExecuteScalar("SELECT count(*) FROM transactions WHERE " & whereClause & " ;"))
If count = 0 Then
MyFunctions.IsSubmitted = True
Return False
Exit Function
Else
MyFunctions.IsSubmitted = False
Return True
Exit Function
End If
Help please
Thanks