writing update query through servoy code.

Classic Servoy
1

Hi All,

Can we write update sql query through the servoy code ?. getDataSetBYQuery is only used for select statements.

2

Hi,

You can use the rawSQL plugin for this.

3

Hi Roberts,

Thanks for your help.

4

Hello,

You can also you the . getDataSetBYQuery to update the database, if you call a procedure on the backend database.

sample sql:

select * from (call AR_UPDATECUSTOMERBALANCE(‘ABC001’,‘100.00’))

Lach

5

You may also have a look at the foundsetupdater.

databaseManager.getFoundSetUpdater(foundset)

Rob