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
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
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
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
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
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
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
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,
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
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
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
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
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.
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
14 matches
Mail list logo