Android Question SQLite DB Insert and Update result

[Mark Stuart]

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.

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.

 

[Erel]

You should use ExecNonQuery for non-select commands. It will throw an exception if the command failed.