Hi,
I ran into something I don't understand, maybe someone here can shed some light
on it for me.
I have a table named Tg which is created (with tcl) by:
CREATE TABLE Tg (TgConfigId INTEGER PRIMARY KEY AUTOINCREMENT,
OtherColumn INTEGER);
If I do:
INSERT INTO Tg (TgConfigId) VALUES (1);
The following select works:
SELECT * FROM Tg WHERE TgConfigId = 1;
But if I insert '1' instead I have to select on '1', 1 no longer works. That
makes some sense, but not entirely, as what I inserted isn't an integer any
longer but a string. Why would I be allowed to insert values with '' in a
column that is specified to be an integer?
Regards,
Tobias
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
