# Error running update query

**URL:** <https://forum.inductiveautomation.com/t/error-running-update-query/19960>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [October 3, 2018, 3:44pm UTC](https://forum.inductiveautomation.com/t/error-running-update-query/19960 "2018-10-03T15:44:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Post date:** [October 3, 2018, 3:44pm UTC](https://forum.inductiveautomation.com/t/error-running-update-query/19960/1 "2018-10-03T15:44:48Z")

</div>

One of my pages have an SQL query binding on a custom property named _dsBollaData_ - a SELECT statement with a WHERE clause based on another custom property  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4a0f6ad7dc50459f1b36ba258620933981bec688.png)  
The other components draw there values from the custom property _dsBollaData_ by means of a lookup.  
If I login/logout when that page is displayed I get the following error message:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/828bd8d256432fdb50e35b61a73695b37312c4ec.png)  
as if the _dsBollaData_ custom property had an UPDATE statement too, which is not the case.

Ignition version: 7.9.8 (b2018060714)  
Java version: 1.8.0\_172

Any suggestion?

Thanks in advance, regards

---

<div class="post-metadata">

**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:** [October 3, 2018, 3:52pm UTC](https://forum.inductiveautomation.com/t/error-running-update-query/19960/2 "2018-10-03T15:52:19Z")

</div>

Update to 7.9.9; this is a bug that was present in 7.9.7 and 7.9.8.

---

<div class="post-metadata">

**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Post date:** [October 4, 2018, 10:34am UTC](https://forum.inductiveautomation.com/t/error-running-update-query/19960/3 "2018-10-04T10:34:47Z")

</div>

Many thanks, I will do it as soon as I can.