# Error when attempting to edit a boolean value linked to a MySQL database

**URL:** <https://forum.inductiveautomation.com/t/error-when-attempting-to-edit-a-boolean-value-linked-to-a-mysql-database/74977>\
**Category:** Ignition\
**Tags:** perspective, scripting\
**Created:** [June 13, 2023, 7:33pm UTC](https://forum.inductiveautomation.com/t/error-when-attempting-to-edit-a-boolean-value-linked-to-a-mysql-database/74977 "2023-06-13T19:33:58Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [June 13, 2023, 8:59pm UTC](https://forum.inductiveautomation.com/t/error-when-attempting-to-edit-a-boolean-value-linked-to-a-mysql-database/74977/9 "2023-06-13T20:59:58Z")

</div>

I like to use named queries with [system.db.runNamedQuery](https://docs.inductiveautomation.com/display/DOC81/system.db.runNamedQuery).

You can refresh the table like this:

```auto
self.getSibling("Table").refreshBinding("props.data")

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-when-attempting-to-edit-a-boolean-value-linked-to-a-mysql-database/74977)._