Hi, I am creating a GUI to SQLite for my final year projectat University so that the user need not know SQL in order to create a database.
I am having trouble when trying to create triggers. The example shown on th SQLite website only shows one example for "UPDATE OF" which seems to be the easist of all triggers to create. I am unsure of the following things and would like some help on the answers please:- do you only need the column name when "UPDATE OF" is chosen and not the other 3? do you need either "BEFORE" or "AFTER" only when "INSERT", "DELETE", or "UPDATE" are chosen, but not when "UPDATE OF" is chosen? when would the "WHEN" option be required and what is the "expression" part of the WHEN clause? Many thanks John
