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
I use SQLite ODBC with ADO to access databases from VB. It works like a charm.
http://www.ch-werner.de/sqliteodbc/
__
Raymond Irving
Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
I use this wrapper and to simplify again the code, I created littles classes
which are very simple and look like the DA
On May 14, 2004, at 10:08 AM, [EMAIL PROTECTED] wrote:
Hello Dr. Hipp,
Hello SQLite users,
I have two tables with data ( persons and products) and a
third table, that cople the Person.ID with the product.ID.
Now I want a left join between the persons and the products,
so I can show all people,
Hello Dr. Hipp,
Hello SQLite users,
I have two tables with data ( persons and products) and a
third table, that cople the Person.ID with the product.ID.
Now I want a left join between the persons and the products,
so I can show all people, and in case they are coppled to a
product, als show th
> if you want to use a field in the SELECT list ...
> then that field has to be in the GROUP BY list.
> Its an error if you don't.
That's true in std SQL92, but SQLite allows it, as does MySQL,
apparently because it makes sense in some circumstances. The
value returned for the non-grouped column
To all VB users out there trying to figure out how to use sqlite in VB:
I have written a COM wrapper in ATL which features an ADO like object model
(Connection and Recordset). From the tests I've run, it's quite fast. It
doesn't need a separate sqlite.dll (sqlite source is in the COM wrapper).
Ju
> > On MS SQL Server 2000, one can pass a field name to the COUNT function,
and
> > though I haven't yet seen any difference in the results between the two,
the
> > queries run faster with COUNT() than with COUNT(*).
>
> COUNT(fieldname) provides the count of rows where the data in 'fieldname'
is
>
"Brass Tilde" <[EMAIL PROTECTED]> writes:
>> And COUNT doesn't take any arguments anyway, besides '*', as
>> they don't make sense.
>
> On MS SQL Server 2000, one can pass a field name to the COUNT function, and
> though I haven't yet seen any difference in the results between the two, the
> queri
> And COUNT doesn't take any arguments anyway, besides '*', as
> they don't make sense.
On MS SQL Server 2000, one can pass a field name to the COUNT function, and
though I haven't yet seen any difference in the results between the two, the
queries run faster with COUNT() than with COUNT(*).
Go f
Thanks for the info :)
I might have typo in the original email because all of these cols do exist
in my database, and this query does in fact run -- which I agree is a little
odd. I did run it with both ClientIP and ClientDomain in the GROUP BY -- it
ran either way (bug?).
I completely forgot ab
SQLite: 2.8.13
OS: HP-UX B.11.11
Hi,
char and varchar fields containing digits only are
dumped without qoutes:
sqlite> create table my_table(id integer primary key, A varchar(25), B char(25));
sqlite> insert into my_table values(NULL, '1234567890','1234567890');
sqlite> insert into my_table
On Thursday 13 May 2004 18:25, Christian Smith wrote:
> On Thu, 13 May 2004, David Given wrote:
> >I'm running sqlite 0.8.6 on a Debian stable build. I have no idea whether
> > it's been compiled with the thread-safety flag or not, there are no
> > release notes.
>
> Not sure whether that's a typo
12 matches
Mail list logo