Android Question Update 2 Joined Tables SQLITE

Jay Young

Member
Licensed User
Longtime 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
 
Sort by date Sort by votes

Jay Young

Member
Licensed User
Longtime 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))
 
Upvote 0
You must log in or register to reply here.

Similar Threads

Y
  • Question
Android Question [Supabase] [SOLVED] Many-to-Many JOIN Table
Replies
0
Views
592
yiankos1
Y
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
61K
Erel
  • Article
B4J Library [B4X] DBUtils 2
2 3 4
Replies
76
Views
52K
Fizzy
F
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
144K
Erel
M
  • Article
B4A Library [Class] Flexible Table
64 65 66
Replies
1K
Views
283K
Sergey_New
S
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…