Hi, I would like to file a documentation bug. On the Create Trigger documentation page, http://www.sqlite.org/lang_createtrigger.html, there is no reference to the default behavior of a trigger when BEFORE, AFTER, or INSTEAD OF clause is not specified. The relevant text is under the main "Create Trigger" heading:
"The BEFORE or AFTER keyword determines when the trigger actions will be executed relative to the insertion, modification or removal of the associated row." This should be changed to include that BEFORE is the default when no clause is specified, especially with the cautions and warnings of using BEFORE, as listed under heading, "Cautions On The Use Of BEFORE triggers." I have searched the rest of the documentation as well and have not found any page that states that BEFORE is the default trigger clause, nor have I found any bugs filed against this request before. Thanks, Jamie _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users