Android Question sqlite nonexec update query

merlin2049er

Well-Known Member
Licensed 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.
 
Top