# runPrepUpdate questions

**URL:** <https://forum.inductiveautomation.com/t/runprepupdate-questions/76746>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [July 22, 2023, 9:02pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-questions/76746 "2023-07-22T21:02:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [July 22, 2023, 9:02pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-questions/76746/1 "2023-07-22T21:02:29Z")

</div>

I have couple question about the runPrepUpdate:

1. Does the query need to be in order? Like:  
system.db.runPrepUpdate("INSERT INTO sometable (who, what, when, where) VALUES(?,?,?,?)", [who, what, when, where])

OR can the items in the ( ) be in different order than the items in the ? Like:  
system.db.runPrepUpdate("INSERT INTO sometable (who, what, when, where) VALUES(?,?,?,?)", [who, what, where, when])

1. Do the items in the need to match the column names in the table your writing to?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [July 22, 2023, 9:09pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-questions/76746/2 "2023-07-22T21:09:11Z")

</div>

Yes, they need to be in order, because no, the name of the variables you pass in doesn't matter.