Android Question SQLite Check if row exists in table

[arsalan945]

Before insert new Record How to Check if Record already exists in table

Example
id___Name___P.Code
1___Howard__24
2___Roberts__64
3___Jack______74
4___Edwards__64
5___Daniel___ 33


Thanks.
Hello All,
I am newbie at B4A

 

[Erel]

If sql.ExecQuerySingleResult2("SELECT count(*) FROM table1 WHERE id = ?", Array As String(3)) > 0 Then
    Log("exists")
End If