Thank you all for your Reply...... I figured out the problem.. I added constraint for the Primary Key in Employee Table, then it got solved. I have missed to add constraint,, and it was the issue.
On Wed, Sep 28, 2011 at 1:41 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Tue, 27 Sep 2011 14:58:06 +0400, Madhan Kumar > <askmad...@gmail.com> wrote: > > >Hello.. > > In sqlite (version 3.7.7.1), I created two tables with foreign keys > >as shown below > > > >CREATE TABLE [*Employee*] ( > > [*EmpId*] INT NOT NULL, > > [EmpName] VARCHAR2(50)); > > > >CREATE TABLE [*Department*] ( > > [DeptID] INTEGER NOT NULL, > > [DeptName] VARCHAR2(20), > > [*EmpID*] INTEGER NOT NULL CONSTRAINT [FK_EMP_Dept] REFERENCES > >[Employee]([*EmpId*])); > > > >Using sqlite Expert Tool, > >I inserted a row in *Employee* Table - Success > >when i want to delete the same row from Employee table - gives error > >"foreign key mismatch". > > > >When i try to insert a row in *Department* Table, gives error "foreign key > >mismatch". > > > >I tried executing PRAGMA foreign_keys = ON > >and it returns "1" > > > >But still i am getting errors. Pls assist me to fix this issue. > >Thanks in advance. > > I think you have the reference the wrong way around. > Employee should reference Department, the relation is n:1. > > The way you have it now, Department references employee, which > means a department can only have one employee. > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > 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
