RE: [sqlite] Another sybase conversion question

2007-02-03 Thread Joe Wilson
t;[EMAIL PROTECTED]> 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 co

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\)
I had more time. -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 syba

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 || ',' || b.CD

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 transla

[sqlite] Another sybase conversion question

2007-02-02 Thread Anderson, James H \(IT\)
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 || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent b,