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) <[email protected]>wrote: > You could've tested this in the time it took for you to get answer: > > > > From: [email protected] 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
