# SQL Query Manual Update

**URL:** <https://forum.inductiveautomation.com/t/sql-query-manual-update/6704>\
**Category:** General Discussion\
**Created:** [June 13, 2013, 2:41pm UTC](https://forum.inductiveautomation.com/t/sql-query-manual-update/6704 "2013-06-13T14:41:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![drettberg](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@drettberg](https://forum.inductiveautomation.com/u/drettberg)\
**Post date:** [June 13, 2013, 2:41pm UTC](https://forum.inductiveautomation.com/t/sql-query-manual-update/6704/1 "2013-06-13T14:41:27Z")

</div>

How can we manually update a SQL Query that is calling a stored procedure? I found the post where you can add a client tag and use that in the query to retrigger.

SELECT Col FROM Table WHERE {[~]MakeQueryUpdate} IN (0,1)

I suppose I could add a dummy parameter to the stored proc and do the same thing, but hopefully there’s a better approach.

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [June 13, 2013, 6:14pm UTC](https://forum.inductiveautomation.com/t/sql-query-manual-update/6704/2 "2013-06-13T18:14:36Z")

</div>

We just spoke on the phone, but I wanted to answer this in case someone else runs into the same problem.

You can use the system.db.refresh() scripting function to force any query to be re-run. You can put this in a button on-screen, or a timer, or anywhere else you have an event script.