# Force refresh of a named query binding for table

**URL:** <https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [January 16, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354 "2024-01-16T21:54:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sherman](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@sherman](https://forum.inductiveautomation.com/u/sherman)\
**Post date:** [January 16, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354/1 "2024-01-16T21:54:32Z")

</div>

I have the data field for a vision Table object bound to a SQL/Named Query. I want to re-run said query upon clicking a button. Is there a way to do this that doesn't involve running the query in the button and then setting the .data field? I am hoping for something akin to myTable.refresh()

---

<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:** [January 16, 2024, 9:58pm UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354/2 "2024-01-16T21:58:44Z")

</div>

Yes, use `system.db.refresh()`. You supply the component reference and the property name, it re-executes that property's binding.

---

<div class="post-metadata">

**Author:** ![sherman](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@sherman](https://forum.inductiveautomation.com/u/sherman)\
**Post date:** [January 16, 2024, 10:00pm UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354/3 "2024-01-16T22:00:25Z")

</div>

Perfect! Thanks phil, that's exactly it.

---

<div class="post-metadata">

**Author:** ![sherman](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@sherman](https://forum.inductiveautomation.com/u/sherman)\
**Post date:** [January 17, 2024, 12:59am UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354/4 "2024-01-17T00:59:04Z")

</div>

FYI -- this is not synchronous. I've spent the last half hour chasing a bug that turns out to be that this update is slower than the execution of the next line in the script. I suppose since its a system call I could have guessed that, but I didnt.

---

<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:** [January 17, 2024, 1:02am UTC](https://forum.inductiveautomation.com/t/force-refresh-of-a-named-query-binding-for-table/84354/5 "2024-01-17T01:02:53Z")

</div>

> [@sherman](#):
>
> FYI -- this is not synchronous

That's correct. Query and tag bindings are entirely asynchronous. Anything that depends upon data arrival should be in a propertyChange event, or in a chained binding. (So too in Perspective.)