Re: [sqlite] Re: Help on triggers

2006-08-05 Thread John Newby
Hi Igor, thanks for your help. Is the 'WHEN' clause used very often when creating triggers or do you think I could get away with leaving it out? I am unsure as what to put in the expression part of the WHEN clause in order to test it thoroughly. Also does anyone have a test database I could use

[sqlite] Re: Help on triggers

2006-08-05 Thread Igor Tandetnik
John Newby <[EMAIL PROTECTED]> wrote: do you only need the column name when "UPDATE OF" is chosen and not the other 3? Correct. do you need either "BEFORE" or "AFTER" only when "INSERT", "DELETE", or "UPDATE" are chosen, but not when "UPDATE OF" is chosen? BEFORE and AFTER keywords are opti