Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Daniel Lee Kruse 
Frank Baumgart wrote:
D. Richard Hipp wrote:
(3)  Remove the COPY command all together.

For the reasons you gave below, esp. to keep the size down
(on an embedded system)
Frank Baumgart
[snip]
I second Frank's response.
--
Daniel Lee Kruse
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

2004-05-20 Thread Daniel Lee Kruse 
Fred Williams wrote:

-Original Message-
From: Michael Roth [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 9:10 AM
To: Ulrik Petersen
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Newbie --question about multiple PCs accessing
sqlite
Ulrik Petersen wrote:

- Mingw or Cygwin (google for each)
www.mingw.org, www.cygwin.com

- Microsoft Visual C++ Toolkit 2003. Microsoft recently released their
compiler and toolchain for free download:
http://msdn.microsoft.com/visualc/vctoolkit2003/
Check the license! It is not really fair! Don't use this toolchain.

Yes.  Use Borland's, it is truly free :-)  Don't want to risk Bill missing a
house payment!
http://community.borland.com/museum/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

http://www.openwatcom.org/ is also a possibility.  It is an open source 
C/C++ compiler for several platforms.

--
Daniel Lee Kruse
Pursuant to U.S. code, title 47, Chapter 5, Subchapter II,Section 227, 
any and all unsolicited commercial E-mail sent,to this address is 
subject to a fee of $500.00 U.S. E-Mailing denotes, acceptance of these 
terms. Consult http://www.law.cornell.edu/uscode/47/227.html for details.

"War is an ugly thing, but it is not the ugliest of things.
The decayed and degraded state of moral and patriotic feeling
which thinks that nothing is worth war is much worse.  A man
who has nothing for which he is willing to fight, nothing he
cares about more than his own personal safety, is a miserable
creature who has no chance of being free, unless made so by
the exertions of better men than himself."
   -- John Stuart Mill (1806-1873), British philosopher,
  economist. "The Contest in America," Dissertations
  and Discussions (1859)
"Kill them all!  God will recognize his own."
  -- Abbot Arnaud-Amalric in 1209, during
 the Albigensian Crusade on how to
 differentiate the Cathar heretics
 from the Catholics
"If Microsoft is ever going to produce something that does not suck, it 
is very likely a vacuum cleaner."
 Axel Hagedorn - Darmstadt/Germany - [EMAIL PROTECTED]

Anonymous quotes:
Pay attention to the political views of famous actors.  After all,
pretending to know things is their profession.
(To minimize internet/virus/worm infections, I have a policy of not 
using Micro$oft products)

Ein Volk, Ein Reich, Ein Fuehrer -- NSDAP (Nazi) slogan, 1930s
One World, One Web, One Program -- Microsoft slogan, 1990s
My two cents - Why would Micro$oft pattern a slogan after a Nazi slogan?
Programming today is a race between software engineers striving to build 
bigger and better idiot-proof programs, and the Universe trying to 
produce bigger and better idiots.  So far, the Universe is winning.

Software is cheap, fast, and reliable ... (pick two).
Windows (3.1, 95, 98, ME, NT, 2K, XP): n.
  32 bit extensions and a graphical shell for a
  16 bit patch to an
   8 bit operating system originally coded for a
   4 bit microprocessor, written by a
   2 bit company, that can't stand
   1 bit of competition.
"Friends don't let friends use Windows"
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Re: SQLite version 3 design question: '500'=500?

2004-05-14 Thread Daniel Lee Kruse 
D. Richard Hipp wrote:
George Ionescu wrote:
However, wanting to test how the engine compares strings and numbers:
SELECT 'match' WHERE '500' = 500;
returns 'match'; also, the following statements return the same result:
SELECT 'match' WHERE '500' = 500;
SELECT 'match' WHERE '500' = 499 + 1;
Who can tell me what other SQL database engines do with
the following?
Tested with Postgres V7.3.2:
   CREATE TABLE test1(a VARCHAR(100));
CREATE TABLE
   INSERT INTO test1 VALUES('501');
INSERT 24969 1
   INSERT INTO test1 VALUES('  502  ');
INSERT 24970 1
   SELECT * FROM test1 WHERE a=501;
  a
-
 501
(1 row)
   SELECT * FROM test1 WHERE a=502;
  a
-
(0 rows)
   SELECT * FROM test1 WHERE a<'502';
  a
-
 501
  502
(2 rows)
Or how about this:
   CREATE TABLE test2(b INTEGER);
CREATE TABLE
   INSERT INTO test2 VALUES(503);
INSERT 24973 1
   INSERT INTO test2 VALUES(504);
INSERT 24974 1
   SELECT * FROM test2 WHERE b='503';
  b
-
 503
(1 row)
   SELECT * FROM test2 WHERE b>'503';
  b
-
 504
(1 row)


--
Daniel Lee Kruse
Pursuant to U.S. code, title 47, Chapter 5, Subchapter II,Section 227, 
any and all unsolicited commercial E-mail sent,to this address is 
subject to a fee of $500.00 U.S. E-Mailing denotes, acceptance of these 
terms. Consult http://www.law.cornell.edu/uscode/47/227.html for details.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]