Edit field values with "SQL Addon"
Posted: Thu Jan 28, 2021 2:30 am
Hi there,
i try to correct some data with the "SQL Addon". if i set a playcounter with
the value seems to be updated correctly in the database
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?
i try to correct some data with the "SQL Addon". if i set a playcounter with
Code: Select all
UPDATE [Songs] SET [PlayCounter]=9 WHERE [ID]=10409
Code: Select all
SELECT ID, AlbumArtist, Songtitle, PlayCounter FROM [Songs] WHERE [ID]=10409
Guess i'm doing it wrong?