# Query returned no rows

**URL:** <https://forum.inductiveautomation.com/t/query-returned-no-rows/15157>\
**Category:** Ignition\
**Created:** [August 24, 2017, 11:46pm UTC](https://forum.inductiveautomation.com/t/query-returned-no-rows/15157 "2017-08-24T23:46:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_Castillo](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@Carlos\_Castillo](https://forum.inductiveautomation.com/u/Carlos_Castillo)\
**Post date:** [August 24, 2017, 11:46pm UTC](https://forum.inductiveautomation.com/t/query-returned-no-rows/15157/1 "2017-08-24T23:46:55Z")

</div>

Can u help me with this error please? Im trying change a value on the db "Query returned no rows. For query “_HERE IS MY QUERY_”  
On component:  
6WPHFraConvL1.\_parent.closable

PLEASE…IM NEW IN IGNITION

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [August 25, 2017, 7:27am UTC](https://forum.inductiveautomation.com/t/query-returned-no-rows/15157/2 "2017-08-25T07:27:28Z")

</div>

What’s the context of this error? Can you share your code please, and also the actual query?

From the error alone, I’d guess you’re using some form of system.db.runQuery, which expects a result, but you give it some sort of UPDATE or INSERT statement. For those statements, you need to use system.db.runUpdate.Query.

Or otherwise it’s just an issue with your query.