[Resolved] Updating sqlite database with multiple fields

Solar2D General Questions/Discussion
#1

How do you update a database with multiple fields? I don’t have my computer with me right now so I haven’t tried this one. I just have to ask this before i forget this question in my mind.

take for example this line of code:

[lua]local updateitem = [[UPDATE itemtable SET itemvalue = ‘]] … itemValue … [[’, itemvolume = ‘]]
… volume … [[’ WHERE itemname = ‘]] … itemName … [[’ AND roomholder = ‘]] … currentRoom … [[’
AND itemmoveholder = ‘]] … currentMove … [[’;]][/lua]

What I’m thinking this would do is that it will update the table field itemvalue and itemvolume if the row is equal to this condition [lua]itemname[/lua], [lua]roomholder[/lua] and [lua]itemmoveholder[/lua].

is this correct? [import]uid: 189861 topic_id: 33579 reply_id: 333579[/import]

#2

That is correct. Simply separate the field / value pairs with commas as above and add the where clause to ensure you only update the appropriate record. [import]uid: 106799 topic_id: 33579 reply_id: 133468[/import]

#3

That is correct. Simply separate the field / value pairs with commas as above and add the where clause to ensure you only update the appropriate record. [import]uid: 106799 topic_id: 33579 reply_id: 133468[/import]