# Update Query

**URL:** <https://forum.servoy.com/t/update-query/5060>\
**Category:** Classic Servoy\
**Created:** [November 14, 2005, 7:38pm UTC](https://forum.servoy.com/t/update-query/5060 "2005-11-14T19:38:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![galexander](https://avatars.discourse-cdn.com/v4/letter/g/ec9cab/32.png) [@galexander](https://forum.servoy.com/u/galexander)\
**Post date:** [November 14, 2005, 7:38pm UTC](https://forum.servoy.com/t/update-query/5060/1 "2005-11-14T19:38:34Z")

</div>

I know you can get a dataset by using the databaseManager getDataSetByQuery method but is there a way to run a straight SQL UPDATE statement through the servoy code editor?

thanks in advance

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [November 14, 2005, 7:47pm UTC](https://forum.servoy.com/t/update-query/5060/2 "2005-11-14T19:47:09Z")

</div>

no, not right away, but you can do it with the new rawSQL plugin that is introduced in the Servoy 3 alfa version!

(As far as I know, the plugin also works in 2.2.1)

---

<div class="post-metadata">

**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\
**Post date:** [November 22, 2005, 5:27pm UTC](https://forum.servoy.com/t/update-query/5060/3 "2005-11-22T17:27:49Z")

</div>

Yes, the SQL Raw plugin works in 2.2.1 and higher.

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [November 23, 2005, 11:48am UTC](https://forum.servoy.com/t/update-query/5060/4 "2005-11-23T11:48:25Z")

</div>

Checkout the foundset updater (as found in servoy since 1.2) composes an SQL update for you.