Thomas Lenders wrote: > Actually, what did was create a text file including : > > CREATE TABLE [ART] ([artnr] INTEGER NOT NULL); > CREATE UNIQUE INDEX [IDX_ART] ON [ART]([artnr] ASC); > > INSERT INTO "ART" VALUES('0000000001'); > INSERT INTO "ART" VALUES('0000000002');
Why are you inserting string literals into integer fields? Make it INSERT INTO "ART" VALUES(1); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users