RE: [sqlite] Another sybase conversion question

2007-02-03 Thread Joe Wilson
ROTECTED]> wrote: > Thanks, Joe! That looks like it might be the solution. > > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 02, 2007 9:58 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Another sybase conversion q

RE: [sqlite] Another sybase conversion question

2007-02-03 Thread Anderson, James H \(IT\)
Thanks, Joe! That looks like it might be the solution. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question --- "Anderson, James H (IT)&quo

RE: [sqlite] Another sybase conversion question

2007-02-03 Thread Anderson, James H \(IT\)
. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 6:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question On Fri, 2 Feb 2007, Anderson, James H (IT) wrote: > The following works fine in sybase, but beca

Re: [sqlite] Another sybase conversion question

2007-02-02 Thread Joe Wilson
--- "Anderson, James H (IT)" <[EMAIL PROTECTED]> wrote: > The following works fine in sybase, but because in sqlite "update" does > not support "from" it doesn't work. Is there another way of doing this? > > Thanks, > > Jim > > update C1_credDerivEvent >set CDEvent = a.CDEvent || ',' ||

Re: [sqlite] Another sybase conversion question

2007-02-02 Thread Jeff Godfrey
- Original Message - From: "Rich Shepard" <[EMAIL PROTECTED]> But, if you're going to do much with SQLite, I strongly recommend Mike Owens' "The Definitive Guide to SQLite" by Apress. The index is shamefully bad, but the book is a gem and has been a great help to me. Very highly

Re: [sqlite] Another sybase conversion question

2007-02-02 Thread Rich Shepard
On Fri, 2 Feb 2007, Anderson, James H (IT) wrote: The following works fine in sybase, but because in sqlite "update" does not support "from" it doesn't work. Is there another way of doing this? Jim, I'm in the midst of trying to meet a deadline, so I'll let someone more knowledgable