On 28 Mar 2014, at 6:06am, SongbookDB <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
