Reply to thread

Message

<blockquote data-quote="millamber" data-source="post: 530190" data-attributes="member: 53070">ClarificationThanks ltfearme,I thought that might be the case thanks for the clarification.I downloaded as suggested SQLiteBrowser (thanks).I ran the following SQL commandUPDATE local_episodesSET 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_episodesSET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, 3,LENGTH(EpisodeFilename)) WHERE SUBSTR(EpisodeFilename,1,3)='F:\'&nbsp; 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<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />Millamber</blockquote>

[QUOTE="millamber, post: 530190, member: 53070"] [b]Clarification[/b] 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 :thx: Millamber [/QUOTE]

Verification