It's our standard design to do test "In Transaction" and Trigger Level in trigger. We never used cascade trigger either.
Error handling in trigger is also standard in our design. We have to create large error code base for error interpretion in multiple language. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I suppose we could have tested “In Transaction” but that’s a bit nasty because >it’s implicit and independent of the business logic being passed up and down >the call chain >Apart from anything else, if you have any error handling running on the server >side at all, you need to run it in a transaction to not end up with data >that’s left in an ambiguous state. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
