First of all great script!
However, I've screwed something up by not knowing enough about how MM works and would be very grateful for some assistance.
All I was trying to do was change the path of my files that were still set as \\DESKTOP\... to C:\Documents and Settings. I thought this'd be as simple as using the query:
- Code: Select all
UPDATE Songs SET SongPath = replace(SongPath, "\\DESKTOP", "C:\Documents and Settings\Owner") WHERE SongPath LIKE "\\DESKTOP%"
however after running that the songs wouldn't play and although the path would show up correctly to start with, if I then tried to play one it would change to "[Network]\Documents and Settings..." I then read something about the IDMedia so thought I'd just change all my songs to the same ID that the other working tracks were set as. This made no difference and I eventually ended up changing the IDMedia of all tracks and now none of them work. No matter what number I set it at none of them can be found and the pathname changes to [Network]...
Hope that makes sense, and any help would be much appreciated as I now wont have my usual alarm for the morning.