[quote=Ludek post_id=477551 time=1611852598 user_id=7319]
I guess this happens because the track is already loaded in the memory and shown in the user interface?
[/quote]

That's it. If i restart MMW on the "Pos1"-Node, execute my SQL, and then select the artist, the updates are there.

Thank's a lot!

Great Addon, btw.

[solved]

var list = app.db.getTracklist('SELECT * FROM Songs WHERE ID = 10409', -1);
list.whenLoaded().then(() => {
	listForEach(list, (item) => { 
		item.playCounter = 9;
	});
	list.commitAsync(); // saves the tracks to the database and tag
});

I guess this happens because the track is already loaded in the memory and shown in the user interface?

The correct steps would be something like this:

[code]
var list = app.db.getTracklist('SELECT * FROM Songs WHERE ID = 10409', -1);
list.whenLoaded().then(() => {
listForEach(list, (item) => {
item.playCounter = 9;
});
list.commitAsync(); // saves the tracks to the database and tag
});

[/code]

UPDATE [Songs] SET [PlayCounter]=9 WHERE [ID]=10409

SELECT ID, AlbumArtist, Songtitle, PlayCounter FROM [Songs] WHERE [ID]=10409

Hi there,

i try to correct some data with the "SQL Addon". if i set a playcounter with

[code]UPDATE [Songs] SET [PlayCounter]=9 WHERE [ID]=10409[/code]

the value seems to be updated correctly in the database

[code]SELECT ID, AlbumArtist, Songtitle, PlayCounter FROM [Songs] WHERE [ID]=10409[/code]

shows "9". But the GUI still shows the old value "0", and it will be reset to "old value" +1 after the next playthrough.

Guess i'm doing it wrong?