Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Warren Young
On 6/9/2013 05:21, Stephen Chrzanowski wrote: Warren, when you say "we may be switching the official builds back to Unix mode soon", you're referring only to the Cygwin builds, correct? Of course. The Win32 versions will still be generated as is? I only maintain the Cygwin packages. I

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Warren Young
On 6/9/2013 07:42, Philip Goetz wrote: /path/to/sqlite3.exe db.sqlite on the command line just hangs. It sounds like you're trying to do that from Cygwin's mintty shell. The Windows Console infrastructure isn't particularly robust, so when a third-party program like mintty tries to run a

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Keith Medcalf
MS-DOS or DOS box is a misnomer. It is usually referred to as a "DOS Prompt" by those who think in clickety-pokery mode only. As far as I know, there is no "DOS" version of sqlite3. The Windows command line is a native Win32 Console Mode executable. It will run in any environment that

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Philip Goetz
Also, I can't use the precompiled Windows binary to open databases created with whatever sqlite version the Cygwin Perl DBI uses, but I can use the cygwin sqlite3.exe to open databases created with the precompiled Windows binary. ___ sqlite-users mailing

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Philip Goetz
My sqlite db seems to work when I access it from perl or java. It's only when I use the cygwin executable on the command line that it doesn't work. So all I really need to know is, How can I use the available Windows sqlite binary from http://www.sqlite.org/download.html on the cygwin command

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Igor Tandetnik
On 6/9/2013 11:25 AM, E.Pasma wrote: Possibly INSERT OR REPLACE is useful when multiple columns need to be updated. Only in some circumstances, when suitable UNIQUE constraints are in place. I beiieve the following statement is equivilent to the given update Since the OP hasn't provided

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Petite Abeille
On Jun 9, 2013, at 5:25 PM, E.Pasma wrote: >> Yes, unfortunately. I would love to see some form of UPDATE FROM make it >> into SQLite, but none such exists at the moment. >> -- >> Igor Tandetnik >> > Possibly INSERT OR REPLACE is useful when multiple columns need to be

Re: [sqlite] Updating a table from itself

2013-06-09 Thread E.Pasma
Op 9 jun 2013, om 16:35 heeft Igor Tandetnik het volgende geschreven: On 6/9/2013 4:55 AM, Dave Wellman wrote: For this example I'm updating a single column (c2). If I needed to update multiple columns in the table would I need to use the SELECT construct for each column? Yes,

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Igor Tandetnik
On 6/9/2013 4:55 AM, Dave Wellman wrote: For this example I'm updating a single column (c2). If I needed to update multiple columns in the table would I need to use the SELECT construct for each column? Yes, unfortunately. I would love to see some form of UPDATE FROM make it into SQLite, but

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Philip Goetz
Okay, but is there a simple answer for me, like getting a different build (eg the standard windows build)? I'm confused about the windows builds. There's a "sqlite-shell-win32 command-line shell", which looks like an executable, but it doesn't in fact work from the command line. I can only open

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-06-09 Thread Stephen Chrzanowski
Warren, when you say "we may be switching the official builds back to Unix mode soon", you're referring only to the Cygwin builds, correct? The Win32 versions will still be generated as is? Personally, I've built a very specific VM to build from the Amalgamation source, however, I also keep the

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Dave Wellman
Ok, thanks. Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Kees Nuyt
On Sun, 9 Jun 2013 09:55:30 +0100, "Dave Wellman" wrote: >Hi Igor, > >Many thanks for that. > >For this example I'm updating a single column (c2). If I needed to update >multiple columns in the table would I need to use the SELECT construct for >each column? Yes.

Re: [sqlite] Updating a table from itself

2013-06-09 Thread Dave Wellman
Hi Igor, Many thanks for that. For this example I'm updating a single column (c2). If I needed to update multiple columns in the table would I need to use the SELECT construct for each column? Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118