merlin2049er Well-Known Member Licensed User Longtime User May 16, 2015 #1 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... Code: 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.
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... Code: 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.
merlin2049er Well-Known Member Licensed User Longtime User May 16, 2015 #2 Sorry, my error. Please disregard. Upvote 0
