# A result set was generated for update - SQL Query

**URL:** <https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-sql-query/6338>\
**Category:** Ignition\
**Created:** [April 29, 2013, 8:21am UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-sql-query/6338 "2013-04-29T08:21:09Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [April 29, 2013, 5:53pm UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-sql-query/6338/2 "2013-04-29T17:53:26Z")

</div>

Where are you trying to run it from? Wherever it is, it is trying to run it as an “update”, when you really want it to run like a select. You’ll likely need to use the [system.db.runQuery](http://inductiveautomation.com/support/usermanuals/ignition/system_db_runquery.htm) scripting function or something similar. And in that case, it’ll probably be easier to wrap it up in a stored procedure and just call that.

Regards,

---

_[View the full topic](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-sql-query/6338)._