On Tue, 25 Nov 2008 11:47:10 +0530, "Satish"
<[EMAIL PROTECTED]> wrote in General Discussion of SQLite
Database <sqlite-users@sqlite.org>:
>Hi!
>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
>I am not getting any constraint failed error
Hm, I do get it using the command line tool as downloaded a
few days ago: sqlite_version():3.6.6.1
create table table1 (
recid integer PRIMARY KEY NOT NULL, label text);
create table table2 (
recid INT PRIMARY KEY NOT NULL, label text);
.bail OFF
insert into table1 (label) VALUES ('foo');
select * from table1;
1|foo
insert into table2 (label) VALUES ('foo');
SQL error near line 5: table2.recid may not be NULL
select * from table2;
Which version do you use?
>Regards,
>Satish.G
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
