I'm looking to get back a result that lets me know if a SQLite INSERT, UPDATE, or INSERT OR REPLACE was successful.
I've used the ExecQuerySingleResult2 method, but so far returns NULL.
Any ideas will be welcome.
Thanx,
Mark S.
I've used the ExecQuerySingleResult2 method, but so far returns NULL.
B4X:
Dim InfoID as String = ""
InfoID = Main.SQLcn.ExecQuerySingleResult2("INSERT OR REPLACE INTO AppInfo (InfoID, LocCode, ScanYear, ScanPeriod) VALUES(1, ?, ?, ?)",Array As String(LocCode,ScanYear,ScanPeriod))Any ideas will be welcome.
Thanx,
Mark S.