# Query change causes Null Pointer Exception Error

**URL:** <https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477>\
**Category:** Ignition\
**Created:** [June 14, 2018, 7:10pm UTC](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477 "2018-06-14T19:10:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![paul.winslow](https://avatars.discourse-cdn.com/v4/letter/p/ccd318/32.png) [@paul.winslow](https://forum.inductiveautomation.com/u/paul.winslow)\
**Post date:** [June 14, 2018, 7:10pm UTC](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477/1 "2018-06-14T19:10:07Z")

</div>

Hi All, I’m using Version 7.9.7 and when I need to change a sql query I keep getting a null pointer exception error every time I accept the change. The only way to get out of it is to cancel the changes and delete the custom property dataset and remake it. I’ve not had any trouble in the past. Any Ideas would be great.

---

<div class="post-metadata">

**Author:** ![Stuart](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Stuart](https://forum.inductiveautomation.com/u/Stuart)\
**Post date:** [June 14, 2018, 7:19pm UTC](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477/2 "2018-06-14T19:19:23Z")

</div>

Bug!  
[http://forum.inductiveautomation.com/t/bug-cant-change-sql-query-binding-on-table-for-any-table/18216](http://forum.inductiveautomation.com/t/bug-cant-change-sql-query-binding-on-table-for-any-table/18216)

[http://forum.inductiveautomation.com/t/possible-bug-in-7-9-7/17883](http://forum.inductiveautomation.com/t/possible-bug-in-7-9-7/17883)

Squished in 7.9.8.

---

<div class="post-metadata">

**Author:** ![paul.winslow](https://avatars.discourse-cdn.com/v4/letter/p/ccd318/32.png) [@paul.winslow](https://forum.inductiveautomation.com/u/paul.winslow)\
**Post date:** [June 14, 2018, 7:38pm UTC](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477/3 "2018-06-14T19:38:25Z")

</div>

Thanks I thought I had seen it but couldn’t find it it the forums.
