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