I had asked this a while back but I think my query got Warnocked. I would like to create a TRIGGER (or a CONSTRAINT) that throws an error if an UPDATE query is run *without* a WHERE clause. This would prevent accidentally mucking up the entire database, which, believe you me, I have done more than once, and have been saved only by the magic of Time Machine.
The TRIGGER would allow a full UPDATE of the table only by using some special syntax in the query... like say, by adding something like WHERE 0=0; -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
