# V7.9.8 Query Update Issue **URL:** \ **Category:** Ignition\ **Created:** [August 15, 2018, 2:57am UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260 "2018-08-15T02:57:08Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [August 15, 2018, 2:57am UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/1 "2018-08-15T02:57:08Z")
I just upgraded to V7.9.9. RC1 to get rid of that annoying SQL Query Update issue, but it is still there: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6ac7deab6886a8c24aab6b681767ee7a1d0e4e30.png) Click on Easy Chart Pen Select: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2ba23901ae6c29ceb501a7ae9a5277a18332094e.png) ---
**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 15, 2018, 12:45pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/2 "2018-08-15T12:45:03Z")
If its like partial fix in 7.9.8, you’ll have to go back into every binding that got messed up by editing in either 7.9.7 or 7.9.8. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 15, 2018, 2:45pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/3 "2018-08-15T14:45:50Z")
The RC that’s currently up doesn’t have the latest fix. 7.9.9 final release will have a fix that won’t require going back into these bindings. ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [August 15, 2018, 7:42pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/4 "2018-08-15T19:42:04Z")
I cant find a property on the Easy Chart called .pens ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f799a90c6d0873f90407968c3c53c498ad92713a.png) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a97289f61280390db6bb2aa14f418145a9de289e.png) ---
**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\ **Post date:** [August 15, 2018, 7:55pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/5 "2018-08-15T19:55:01Z")
DB Pens under Chart Configuration ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [August 15, 2018, 8:11pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/6 "2018-08-15T20:11:09Z")
Still don’t see the UPDATE QUERY ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/65f5196e3dc69948cc4af6a6bcaab15abeda7273.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 15, 2018, 8:12pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/7 "2018-08-15T20:12:05Z")
Right - that’s the bug. 7.9.7/7.9.8 enable an update query (because all query bindings are the same under the hood) even thought dataset properties know enough not to give you an update query option. For now, switching to named queries is the best solution. ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [August 16, 2018, 1:55am UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/8 "2018-08-16T01:55:17Z")
Okay, there is going to be a bit of a rant here, so do not take this personal. This is where I have an issue with people sitting in an office not realizing what we guys ( and gals ) are going through out in the field. I have had a working application for 8 years now that you guys have broken with V7.9.8. It was working fine up until then.. Ask Travis about the Flomation eView project and he will concur my statement about how long it has been around. This named queries option popped up recently and i have no idea what it does or how it will impact the current SQL Query query that is shown on the screen shot. Guess i have some reading up to do. \ ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 16, 2018, 9:19pm UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/9 "2018-08-16T21:19:22Z")
> [@Curlyandshemp](#): > > This named queries option popped up recently and i have no idea what it does or how it will impact the current SQL Query query that is shown on the screen shot. Basically, named queries are a drop-in replacement for query bindings - we worked hard to make them as seamless an upgrade process as possible. There's even an option to "upgrade" an existing query binding to a named query. They're not _quite_ as easy to work with, since you have to jump to a different area of the designer to modify a named query, but there are some big advantages (caching, mainly) that make it more than worth switching over. That it fixes this query binding issue (which is definitely unpleasant - no disagreement there) is a side benefit - I would advocate switching to named queries for all the other reasons as well. EDIT: 7.9.9 is now available. ---
**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 18, 2018, 12:52am UTC](https://forum.inductiveautomation.com/t/v7-9-8-query-update-issue/19260/10 "2018-08-18T00:52:44Z")
Sorry to add to the rant, but we jumped right on named queries and they have been very buggy and almost every point release since they were added we have needed right away to fix named query bugs… ☹ I completely agree with the concept and really need the feature of named queries but can’t have Ignition crashing on me, its getting a bad rap around here.