A arsalan945 New Member Dec 7, 2021 #1 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
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 B4X founder Staff member Licensed User Longtime User Dec 12, 2021 #2 B4X: If sql.ExecQuerySingleResult2("SELECT count(*) FROM table1 WHERE id = ?", Array As String(3)) > 0 Then Log("exists") End If Upvote 0
B4X: If sql.ExecQuerySingleResult2("SELECT count(*) FROM table1 WHERE id = ?", Array As String(3)) > 0 Then Log("exists") End If