Servoy 5.1 beta 3

Classic Servoy
16

jcompagner:
the sample of update method does tell you that already:

//3) safely loop through foundset (starts with selected row)
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
fsUpdater.setColumn(‘my_flag’,count++)
}

will see if i can improve the doc itself a bit.

Johan,

From the Servoy Wiki :

//There are 3 types of possible use with the foundset updater
//1) update entire foundset
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn(‘customer_type’,1)
fsUpdater.setColumn(‘my_flag’,0)
fsUpdater.performUpdate()

I am using (the very nice) option 1 in the hope that Servoy translates that into 1 SQL update statement…
You can see here is no need to set the selectedIndex !