Michael, In this particular instance my questions were posed rhetorically to the OP after I had given his trigger a little more thought. But I can be lazy, for sure, so if you don't mind I'll keep your rebuke ready to hand for the next time it's deserved, which should be soon as it's hot and humid here.
Regards Tim Romano Swarthmore PA On Tue, Aug 3, 2010 at 9:10 AM, Black, Michael (IS) <michael.bla...@ngc.com>wrote: > You could've tested this in the time it took for you to get answer: > > > > From: sqlite-users-boun...@sqlite.org on behalf of Tim Romano > Sent: Tue 8/3/2010 6:53 AM > To: General Discussion of SQLite Database > Subject: EXTERNAL:Re: [sqlite] How to write the trigger? > > > > Is a to-be-inserted row supposed to be included among the counted rows in a > BEFORE INSERT trigger? Could you end up with 5 rows? What happens if you > make this an AFTER trigger? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users