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...
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.
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.
