Hi there, > > It's known that triggers aren't SQLite most remarkable strength, even if I > never encountered a situation where their relative slowness significantly > exceeds their usefulness. > In your situation I believe your coumpond triggering condition needs > parenthesis. Your indentation of AND is meaningless to the parser.
You’re quite correct; that was a slip in my copying out the code into this email. The parentheses as you suggest already exist in my trigger. Very many apologies for missing that. Hamish > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users