On 28 Mar 2014, at 6:06am, SongbookDB <shaun_thom...@songbookdb.com> wrote:
> Never mind Simon. It turns out that SQLite allows NULLable fields to > participate in UNIQUE indexes. > > I'd screwed up the code I'd made to replace anything undefined with "". > I've changed it, and it's properly saving empty strings now, and the index > is now successfully ignoring identical row insert attempts. That's great. Glad you've solved your problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
