# Store and Forward a prep-statement?

**URL:** <https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732>\
**Category:** Ignition\
**Created:** [September 19, 2018, 12:38pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732 "2018-09-19T12:38:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julio.Bautista](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Post date:** [September 19, 2018, 12:38pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732/1 "2018-09-19T12:38:19Z")

</div>

If my database connection faulted would a prep-statement query be stored in cache till my connection is reestablished? I’, running this code on a global shared script if that makes any difference.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 20, 2018, 5:03am UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732/2 "2018-09-20T05:03:48Z")

</div>

You would have to use [runSFPrepUpdate()](https://docs.inductiveautomation.com/display/DOC79/system.db.runSFPrepUpdate), and then it would be “yes”.

---

<div class="post-metadata">

**Author:** ![Julio.Bautista](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Post date:** [September 20, 2018, 4:56pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732/3 "2018-09-20T16:56:48Z")

</div>

is it ok to assume that the store and forward will write into my database in the order my queries have been sent to SF?, because my sql table is set for auto increment.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 21, 2018, 2:43am UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732/4 "2018-09-21T02:43:29Z")

</div>

Normally, I would say yes, but I don’t know what might happen with temporary error conditions. Consider including a timestamp in your row data so that there is no ambiguity no matter how long the delay might be.