Hi Igor! You Said me to create the field as "INT PRIMARY KEY" instead of "INTEGER PRIMARY KEY".Even we spell differently they are working same.it is also auto incrementing.
Regards, Satish.G -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Tuesday, November 25, 2008 11:13 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Violating Primary key Constraint "Satish" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks for the reply.The thing I need is I don't want the field to > be > auto incremented Spell the field in some way other than precisely "INTEGER PRIMARY KEY". E.g. "INT PRIMARY KEY" would work as you expect. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users