Code: Select all
SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter= WHATEVER WHERE (Songs.SongTitle = WHATEVER and Songs.Artist = WHATEVER)")
Help...
Code: Select all
SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter= WHATEVER WHERE (Songs.SongTitle = WHATEVER and Songs.Artist = WHATEVER)")
Code: Select all
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' ")