Re: [sqlite] Problems with the UPDATE command

Regards Rodney > To: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Thu, 5 Nov 2009 14:42:30 -0500 > Subject: Re: [sqlite] Problems with the UPDATE command > > Rodney Cocker <rodneycoc...@hotmail.com> > wrote: > > I ran

Re: [sqlite] Problems with the UPDATE command

On Thu, Nov 5, 2009 at 1:28 PM, Rodney Cocker wrote: > > 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,

Re: [sqlite] Problems with the UPDATE command

Rodney Cocker wrote: > 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

[sqlite] Problems with the UPDATE command

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