Android Question Data Exist in the database

[vinzpogi]

I have a problem with my code here. In my database

idnumber | firstname | middlename | lastname | gender | username | password | usertype
1001 qwe qwe qwe Male admin admin Admin
1002 abc abc abc Male user user User

When i try to register that data again, the app force closes. But i have an If statement saying it will show a toastmessage if it exist already. Is there a missing code here or is there something wrong with my query?

 

[Erel]

Don't use toast messages to see what's happening. Use Log instead.
Run your app in debug mode and monitor the logs.

You will also see the full error message in the logs.

 

[Lahksman]

In your select query you are using every field for comparison. You should only check on idnumber (I suppose this is a unique field).

Sub RegisterEntry
    Private Query As String
    Private cursor1 As Cursor
   
    Query = "SELECT * FROM adminclient WHERE idnumber = ?"
    cursor1 = sql1.ExecQuery2(Query, Array As String(REGid.text))
   
    If cursor1.RowCount > 0 Then
        ....

If you want to compare other fields aswell you could combine several fields, for instance:

Sub RegisterEntry
    Private Query As String
    Private cursor1 As Cursor
   
    Query = "SELECT * FROM adminclient WHERE (idnumber = ?) OR (firstname = ? AND middlename = ? AND lastname = ?)"
    cursor1 = sql1.ExecQuery2(Query, Array As String(REGid.text, REGfirst.text, REGmid.text, REGlast.text))
   
    If cursor1.RowCount > 0 Then
        ....

You are now checking on ID or combination of first, middle and lastname.

 

[vinzpogi]

@Erel Thanks for the tip !

@Lahksman Thank you for this ! It shows that the entry already existed now!

 

[sankalp patil]

Nice Suggestion.
This help us also for resolving the similar problem.