Raheel Gupta wrote: >INSERT INTO checksums (1000, "abcdefghijklmnop") ON CONFLICT IGNORE BUT >UPDATE data SET isUnique = OLD.checksums.i > >Is this possible with HOOKS / triggers or anything at all ?
It is possible with the obvious and simple solution: check for uniqueness with a SELECT, then execute either INSERT or UPDATE as needed. Is there any reason that you do not want to use this? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
