dataset.setValue Not save data in the Database

Classic Servoy
1

Hello

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

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();
2

A JSDataSet is not connected to a database table, only JSFoundSets are!

A JSDataSet is just a collection of data in columns and rows, with some convenient methods.

Just like a multi dimensional Array is not connected to the database:
var multiDimensionalArray = [[0a,0b, 0c],[1a, 1b, 1c],[2a,2b,2c],[3a,3b,3c]];
multiDimensionalArray[4] = [4a,4b,4c];

If you would update a value in the array, off course nothing would change in the database, because it has no knowledge of the database.

Paul

3

Many tanks!!!

4

gzola:
Many tanks!!!