Android Question Update 2 Joined Tables SQLITE

Discussion in 'Android Questions' started by Jay Young, Jun 1, 2015.

  1. Jay Young

    Jay Young Member Licensed User

    How do you use the UPDATE statement to Update two joined tables in SQLite, I have table1 that has 9 columns in it and i Join Table2 that has 1 column in it with a Select statement, I want to be able to UPDATE both tables at the same time.

    Hope this is clear

    Thanks for any help
    Jay
     
  2. Jay Young

    Jay Young Member Licensed User

    this is the code i have been working on,


    Query = "UPDATE inventory SET item = ?, instock = ?, ordamt = ?, Type = ?, container = ?, date = ?, flag = ? Where _id = " & edtDbIdUP
    Cursor1 = Main.SQL100.ExecQuery2(Query, Array As Object(edtItemUP, edtInStockUP, edtOrdAmtUP, edtTypeUP, edtContainerUP, edtDateUP, edtFlagUP))

    Query2 = "UPDATE monday SET pars = ? WHERE _id = " & edtDbIdUP
    Cursor2 = Main.SQL100.ExecQuery2(Query2, Array As Object(edtParsUP))
     
  3. Erel

    Erel Administrator Staff Member Licensed User

    You should use ExecNonQuery2 for an UPDATE command.
     
Loading...