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
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 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(field) than with COUNT(*).
COUNT(fieldname) provides the count of rows where the data in 'fieldname'
is
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).
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 DAO