Once used the method setValue to change values of records in a dataset, how do you save your changes back to Database?
Using Servoy 3.5.10 and MySql 5.0
Thanks for your help
- Code: Select all
query = "SELECT quozientiid, fkid_coalizione, quoz_coaliz, flag_seggio, order_quoz, num_seggio_coaliz " +
"FROM quozienti " +
"WHERE fkid_tornata = 35 AND fkid_coalizione = 206 " +
"ORDER BY quoz_coaliz desc";
quozCoalizVincente = databaseManager.getDataSetByQuery(controller.getServerName(), query, null, 1000)
for( var j=1 ; j <= 24 ; j++ )
{
quozCoalizVincente.setValue(j, 4, 1); //flag_seggio = 1;
quozCoalizVincente.setValue(j, 5, j); //order_quoz = j
var test = quozCoalizVincente.getValue(j,5);
}
//This not working
var success = databaseManager.saveData();