# Update More than one Value with SQLITE

**URL:** <https://discourse.nodered.org/t/update-more-than-one-value-with-sqlite/4542>\
**Category:** General\
**Created:** [3 November 2018 23:07 UTC](https://discourse.nodered.org/t/update-more-than-one-value-with-sqlite/4542 "2018-11-03T23:07:06Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ilvesheimer](https://avatars.discourse-cdn.com/v4/letter/i/dbc845/32.png) [@ilvesheimer](https://discourse.nodered.org/u/ilvesheimer)\
**Post date:** [3 November 2018 23:54 UTC](https://discourse.nodered.org/t/update-more-than-one-value-with-sqlite/4542/3 "2018-11-03T23:54:48Z")

</div>

I've already tried this version, but it didn't work for me.

But i just found the problem, i used the "Via.msg.topic" option as \</\> SQL Query in the sqlite node options.  
Now i switched to Batch without response and included the 'BEGIN TRANSACTION' and 'COMMIT' again and now it works.

It would be nice if someone can explain whats the difference between those two options, but it works for me now.

---

_[View the full topic](https://discourse.nodered.org/t/update-more-than-one-value-with-sqlite/4542)._