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

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 +

Re: [sqlite] sqlite with Visual Basic

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

[sqlite] SQLite COM Wrapper written in ATL

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).

Re: [sqlite] Question about expected query result??

> > 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

[sqlite] Varchar with numbers dumped without quotes

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

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

Hello Dr. Hipp, Hello SQLite users, CREATE TABLE test1(a VARCHAR(100)); INSERT INTO test1 VALUES('501'); INSERT INTO test1 VALUES(' 502 '); SELECT * FROM test1 WHERE a=501; SELECT * FROM test1 WHERE a=502; SELECT * FROM test1 WHERE a<'502'; in MS SQL Server yelds the