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

Reply via email to