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
_________________________________________________________________
Looking to move this spring? With all the lastest places, searching has never
been easier. Look now!
http://clk.atdmt.com/NMN/go/157631292/direct/01/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
