"Satish" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You Said me to create the field as "INT PRIMARY KEY NOT NULL" instead > of "INTEGER PRIMARY KEY NOT NULL".Even we spell differently they are > working > same.it is also auto incrementing. > > sqlite> create table dummytable (recid integer PRIMARY KEY NOT NULL, > label text); > sqlite> insert into dummytable (label) VALUES ('foo'); > sqlite> select * from dummytable; > 1|foo > sqlite> create table secondtable (recid INT PRIMARY KEY NOT NULL, > label > text); > sqlite> insert into secondtable (label) VALUES ('foo'); > 1|foo
Are you suggesting the last "1|foo" output was produced by "insert into secondtable" statement? With all due respect, I find it hard to believe. Anyway, the statements you show work for me as expected, in that the last insert statement does produce an error. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
