On 10 Feb 2011, at 11:55pm, Yuzem wrote: > That's the beauty of using a additional table. I make the column unique in > the the extra table and then on any insert in "movies people" I insert in > for example the directors table and any duplicate will be automatically > rejected. > > The same problem exist on delete, the deleted entry may not be unique. > > For example: > movie1|director|people1 > movie2|director|people1
Erm ... there are also movies which have more than one person directing. You need to copy across the rowid from the MoviePeople table, and delete just based on that particular record. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users