Just a follow up on this - INSERT is the correct behaviour in this case - you are creating a NEW song title when edit it, therefore it has to create a new record in the Song Titles table - this is because if that song title was ALSO in use on another song, you wouldn't want it to be edited on that one as well - therefore a new SongTitle record is created and the Song record is altered to use that SongTitle instead.

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

I have changed the compatiblilty levels in SQL from 2012 to 2008 and this didn't make any differece.  I will now try an 2008R2 instance and confirm the results.

I am still having the issue but now I'm using SQL SVR 2008R2 Express.

It must be something in the database causing this issue.  I can supply the AutoTrack v3 file if I can be provided with an upload link.  Any other ideas, I will try a new DB and see if I have the same issue, it will then rule out in import. 

Hi Shane,

Actually, looking at it it is possible that this will happen as we query SQL to see if a title is already there, and if it is then the record isn't updated - and that query is case insensitive to make sure that plain text searching always comes back with the correct answers.

If you do need to correct casing, then if you go into Songs>Song Management you can edit the titles directly in there to correct casing.

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

This is doing the same in a new DB.

1/ Create new song - link to AudioWall to pull in Artist Title in the same case as the audio wall - This works
2/ Change the case in the song in AutoTrack and force the change to the Audiowall - This works but AutoTrack does not read the corrections made

Functaionality:- What happens now....

1/ Searching the cart in AutoTrack shows the incorrect case even after re-importing from the Audiowall to overwrite the details.

The reason why, and I'm not sure if rules have changed is that AutoTrack 3 saw the same artist with different case casuing same artist songs in a clock. Ie  Elvis Presley, elvis preseley, Elvis presley and elvis Presely.

I am trying to make sure that all artists in our DB are corrected and changes sent to the AudioWall or vice-versa.

Hi Shane,

I don't think casing could have caused them to break artist separation - the artist separation is done by whether it's the same ArtistNumber, during scheduling we don't do any text matching. However a mistype would cause it - e.g. Elvis Presley vs Elvis Presely (I appreciate your typos above are accidental though!)

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

I have just made the change in Song Management and this works but from this screen I'm unable to update the cart on the audiowall with the title correction.  So as a feature request I would like to change this from the Cart if possible to correct casing this would save us alot of time as carts can be corrected in once place.