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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users