Android Question sqlite nonexec update query

merlin2049er

Well-Known Member
Licensed User
Longtime User
I'm not sure what I'm doing wrong...

I've got a table that I'd like to update certain fields within the table. My updates are erasing the values of the previous update...

B4X:
SQLcommand = "UPDATE bingo SET h" & currenthole & "=  1  WHERE id=" & playerselected & ";"
SQL1.ExecNonQuery(SQLcommand)

It's basically a golf score card, and the sql statement is generated after each hole is scored, so h & currenthole is incremented.

I've tested the updates within sqlite browser, and sqlite manager (on android) and it works.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…