Hi Igor!
Thanks for the reply.The thing I need is I don't want the field to be
auto incremented it should show me the error that constraint violated even
if I give NULL or empty value.how can I do this.Don't send me links which
doesn't have matter at all.First 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@sqlite.org
Subject: 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 Example
>
> Create table emp(empno integer PRIMARY KEY,...,...)
>
> . Even if I give u a NULL as a value to the field that is
> declared as primary key .it is accepting
http://sqlite.org/autoinc.html
--
With best wishes,
Igor Tandetnik
With sufficient thrust, pigs fly just fine. However, this is not
necessarily a good idea. It is hard to be sure where they are going to
land, and it could be dangerous sitting under them as they fly
overhead. -- RFC 1925
_______________________________________________
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
