# dataset.setValue Not save data in the Database

**URL:** <https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171>\
**Category:** Classic Servoy\
**Created:** [May 11, 2010, 10:05am UTC](https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171 "2010-05-11T10:05:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gzola](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@gzola](https://forum.servoy.com/u/gzola)\
**Post date:** [May 11, 2010, 10:05am UTC](https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171/1 "2010-05-11T10:05:27Z")

</div>

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

```auto
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();

```

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [May 11, 2010, 10:21am UTC](https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171/2 "2010-05-11T10:21:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![gzola](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@gzola](https://forum.servoy.com/u/gzola)\
**Post date:** [May 11, 2010, 10:37am UTC](https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171/3 "2010-05-11T10:37:17Z")

</div>

Many tanks!!!

---

<div class="post-metadata">

**Author:** ![dfrazier](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@dfrazier](https://forum.servoy.com/u/dfrazier)\
**Post date:** [March 29, 2013, 7:51pm UTC](https://forum.servoy.com/t/dataset-setvalue-not-save-data-in-the-database/12171/4 "2013-03-29T19:51:31Z")

</div>

> gzola:  
> Many tanks!!!