# SQL Binding Update Query Disabled

**URL:** <https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [August 24, 2018, 2:25am UTC](https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398 "2018-08-24T02:25:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [August 24, 2018, 2:25am UTC](https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398/1 "2018-08-24T02:25:08Z")

</div>

FYI - I just sent this off to support, but it took us a day of head scratching to find it, so wanted to give others a heads up if they encounter the same.

After upgrading to 7.9.9 (from 7.9.8) in one of our projects, the Update query on a SQL binding was disabled. We had to go back in, manually enable and re-publish.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6e9ff3f88f2bfe653e07385bb2f42d2cd4f1ce53.png)

---

<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:** [August 24, 2018, 12:22pm UTC](https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398/2 "2018-08-24T12:22:20Z")

</div>

{ Giggle… }  
Sorry, been there, done that (overshoot on a bugfix). /-:

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [August 24, 2018, 12:42pm UTC](https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398/3 "2018-08-24T12:42:06Z")

</div>

ahhhh yup, I see it now. [V7.9.8 Query Update Issue](http://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/10)

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [August 24, 2018, 12:44pm UTC](https://forum.inductiveautomation.com/t/sql-binding-update-query-disabled/19398/4 "2018-08-24T12:44:27Z")

</div>

I just checked in one of my projects, where I have many screens with many numeric fields that have property binding to the both (select and update) database queries. Every property that I checked was OK (Update query was NOT unchecked).  
I updated my virtual machine yesterday to the 7.9.9. Interesting…😇