Update Query

Classic Servoy
1

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

2

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)

3

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

4

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