I have a Magic Node with the following SQL query to match (or not match) Artist Comments with a certain string. <Group|Name:Comments>\Artist Comment doesn't start with "Sorted Name: "|Filter:Songs.ID NOT IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.ID...

I've gotten this far but keep getting a syntax error. dim strSN : strSN = "Sorted Artist Name: " SQL = "UPDATE Artists SET Artists.Comment = '" & strSN & "' WHERE Artists.Artist = '" & itm.Artist.Name & "'" SDB.database.execSQL(SQL) Any suggest...

Is it possible to attach a property to an artist? I want to track whether an artist's name should be reformatted for sorting (firstname lastname > lastname, first name). I am trying to clean up my library with a script I am working on (self-made). One of the first things is checking whether I want t...