Re: [sqlite] Violating Primary key Constraint

On Tue, 25 Nov 2008 11:47:10 +0530, "Satish" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >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

Re: [sqlite] Violating Primary key Constraint

> Hi All! > > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give any > value to that field an error occurs that violating the constraint > > For Example > > Create table emp(empno integer PRIMARY

Re: [sqlite] Violating Primary key Constraint

"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

Re: [sqlite] Violating Primary key Constraint

able (label) VALUES ('foo'); > 1|foo > I am not getting any constraint failed error > > Regards, > Satish.G > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ian Walters > Sent: Tuesday, November 25, 2008 11:17 AM >

Re: [sqlite] Violating Primary key Constraint

ds, Satish.G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Walters Sent: Tuesday, November 25, 2008 11:17 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Violating Primary key Constraint Hi Satish, I just re-read your original email and

Re: [sqlite] Violating Primary key Constraint

D] 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 wa

Re: [sqlite] Violating Primary key Constraint

rst try to understand the problem and then give > me reply. > > Regards, > Satish.G > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik > Sent: Tuesday, November 25, 2008 10:59 AM > To: sqlite-users@sqli

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

Re: [sqlite] Violating Primary key Constraint

and then give me reply. Regards, Satish.G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Tuesday, November 25, 2008 10:59 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Violating Primary key Constraint "Satish" <[EM

Re: [sqlite] Violating Primary key Constraint

On 11/24/08, Satish <[EMAIL PROTECTED]> wrote: > Hi All! > > > > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give any > value to that field an error occurs that violating the constraint > > For Example

Re: [sqlite] Violating Primary key Constraint

"Satish" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give > any value to that field an error occurs that violating the constraint > > For

[sqlite] Violating Primary key Constraint

Hi All! I have created a table in sqlite.Upto my knowledge a column which is declared as primary key will not accept null and even if I don't give any value to that field an error occurs that violating the constraint For Example Create table emp(empno integer PRIMARY KEY,...,...) .