Gött mos, Spanks !

I thought it was something like that but I couldn't get it to work :P

SDB.Database.ExecSQL("UPDATE Songs INNER JOIN Artists ON Songs.IDArtist = Artists.ID SET Songs.PlayCounter = SomeNumber WHERE Songs.SongTitle = 'SomeTitle' AND Artists.Artist = 'SomeArtist' ")

Try this:
[code]SDB.Database.ExecSQL("UPDATE Songs INNER JOIN Artists ON Songs.IDArtist = Artists.ID SET Songs.PlayCounter = SomeNumber WHERE Songs.SongTitle = 'SomeTitle' AND Artists.Artist = 'SomeArtist' ")[/code]

The Artist name is store in the Artists table and not in the Songs table so you need to link the songs table to the Artists table. And don't forget to enclose text values with -> '

SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter= WHATEVER WHERE (Songs.SongTitle = WHATEVER and Songs.Artist = WHATEVER)")

I'm going to update the PlayCounter of some songs and I have the following code:

[code]SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter= WHATEVER WHERE (Songs.SongTitle = WHATEVER and Songs.Artist = WHATEVER)")
[/code]

But Songs.Artist won't work. Neither will Songs.ArtistName etc...
Help... :roll: