Reply to thread

Clarification

Thanks ltfearme,

I thought that might be the case thanks for the clarification.

I downloaded as suggested SQLiteBrowser (thanks).

I ran the following SQL command

UPDATE local_episodes

SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, 3,LENGTH(EpisodeFilename))

WHERE SUBSTR(EpisodeFilename,1,3)='F:\'

Which worked perfectly, but when I went to run it the next time to change any files stored on my H: drive it didn't work.

I performed several tests and I can change either all the records on the F: drive or all the records on the H: drive but not both.

It seems that after the first command, it won't work a second time.

I even tried:

UPDATE local_episodes

SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, 3,LENGTH(EpisodeFilename))

WHERE SUBSTR(EpisodeFilename,1,3)='F:\'  OR SUBSTR(EpisodeFilename,1,3)='H:\'

But this results in none of the records being changed.

Any ideas as to the cause of this behaviour?

TIA

Millamber