# Does the store and forward system work with db update queries?

**URL:** <https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723>\
**Category:** Ignition\
**Created:** [January 28, 2021, 11:36pm UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723 "2021-01-28T23:36:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [January 28, 2021, 11:36pm UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723/1 "2021-01-28T23:36:04Z")

</div>

As in title, do db update calls from script get added into the store and forward system?

---

<div class="post-metadata">

**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\
**Post date:** [January 28, 2021, 11:48pm UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723/2 "2021-01-28T23:48:51Z")

</div>

Isn’t that what these are for?

- [system.db.runSFNamedQuery](https://docs.inductiveautomation.com/display/DOC81/system.db.runSFNamedQuery)

- [system.db.runSFPrepUpdate](https://docs.inductiveautomation.com/display/DOC81/system.db.runSFPrepUpdate)

- [system.db.runSFUpdateQuery](https://docs.inductiveautomation.com/display/DOC81/system.db.runSFUpdateQuery)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [January 29, 2021, 1:00am UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723/3 "2021-01-29T01:00:09Z")

</div>

Well then, I didn’t even know these existed! That’s exactly what I’m after, cheers

---

<div class="post-metadata">

**Author:** ![Herbie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/herbie/32/65288_2.png) [@Herbie](https://forum.inductiveautomation.com/u/Herbie)\
**Post date:** [February 1, 2021, 5:56pm UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723/4 "2021-02-01T17:56:34Z")

</div>

Nick, those are exactly the queries you want to use in order to take advantage of the Store & Forward system. However, one thing that is frustrating with using them, at least in my limited experience, is that updates do not immediately reflect on queries that follow right after. This is more important in how you design something, because sometimes you want to insert/update, then read back current values for display. You will have to build a delay function into your process, or just expect the visual to change once it gets processed by the S&F engine. Otherwise, this is exceptionally helpful to not lose data when leveraging remote database connections.

The other nice feature you can get with the S&F version is the ability to duplicate data to multiple data sources in a single script.