(First of all sorry for my "inglish") 3 tables : Owners Models Cars
My difficult is recreate a kind of "referential integrity" through FK With 2 tables not problem but with 3 cascade table ..... Owner: PK IDowner Models: PK IDmodel Cars: CodOwner CodModel IDowner 1-> many CodOwner IDmodel 1-> many CodModel I write CREATE TABLE [Models] ( [IDcar] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [CODmodel] INTEGER NOT NULL CONSTRAINT [FKmodel] REFERENCES [Models] ([idmodel]) ON DELETE NO ACTION, [CODowner] INTEGER NOT NULL CONSTRAINT [FKowner] REFERENCES [Owners] ([Idowner]) ON DELETE NO ACTION, [DataImmatricolazione] DATE, [Targa] NVARCHAR(20) NOT NULL); But not works!!! message: Abort due to constraint violation. if delete one fk (random) and ....ta dah!... no error but incomplete simulation of "referential integrity" with 3 linked tables! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
