# Disable table update

**URL:** <https://forum.inductiveautomation.com/t/disable-table-update/26460>\
**Category:** Ignition\
**Created:** [July 11, 2019, 1:43am UTC](https://forum.inductiveautomation.com/t/disable-table-update/26460 "2019-07-11T01:43:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jrd](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@jrd](https://forum.inductiveautomation.com/u/jrd)\
**Post date:** [July 11, 2019, 1:43am UTC](https://forum.inductiveautomation.com/t/disable-table-update/26460/1 "2019-07-11T01:43:05Z")

</div>

Good morning  
Does anyone have a method to disable updating a table from sql?  
I’m looking for something like the switch labelled “Live Values” on the Ignition Gateway -\> Status-\> Logs page

Thanks

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [July 11, 2019, 2:11pm UTC](https://forum.inductiveautomation.com/t/disable-table-update/26460/2 "2019-07-11T14:11:05Z")

</div>

You could always use the following setup (written from a Perspective point-of-view, but it can be accomplished in Vision as well):

1. propertyA is a periodic polling (binding) of the table data.
2. LiveValueToggleSwitch (or checkbox) is a component which determines if you should be using live values or “locked” data.
3. propertyA has an onChange Script something like this:

```auto
if ToggleSwitch.props.selected:
    Table.props.data = View.custom.query_value

```

Using this setup will populate your table with the data from the query until you “un-select” the ToggleSwitch or checkbox, at which point the Table will retain whatever data it already had. Toggling the switch will then re-activate the display of live data.

---

<div class="post-metadata">

**Author:** ![SergioS](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@SergioS](https://forum.inductiveautomation.com/u/SergioS)\
**Post date:** [January 19, 2021, 10:56pm UTC](https://forum.inductiveautomation.com/t/disable-table-update/26460/3 "2021-01-19T22:56:23Z")

</div>

Sorry, this solution exist too for version 7.x?

Thanks