On 28 Mar 2014, at 1:12am, SongbookDB <shaun_thom...@songbookdb.com> wrote:

> However, if, for example the DiscId is blank, but the artist and title are
> not, a new record is created when there is already one with a blank DiscId
> and the same artist and title - BAD.

What's the primary key on that TABLE ?  Include both the column name and the 
column's affiliation.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to