Android Question sqlite nonexec update query

Discussion in 'Android Questions' started by merlin2049er, May 16, 2015.

  1. merlin2049er

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

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

    merlin2049er Well-Known Member Licensed User

    Sorry, my error. Please disregard.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice