I want to create a TRIGGER (or some kind of constraint) that would croak when an update is attempted without a WHERE clause (to prevent accidental updates of the entire table). If a conscious update of the entire table is requested then one could just add a WHERE 0=0 kind of a dummy clause, but if there is no WHERE clause, the UPDATE attempt should just fail.
Any hints would be appreciated. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users