Re: "All triggers are evil",..., really?

My system relies heavily on instead_of triggers.

One of the requirements during initial design was that I had to allow
for ODBC connectsions to my database, so users could access the data
with ARC. Since if I allow ODBC, that opens up tremendously what other
kinds of apps could access my database as well. Also, since I have
little to no control over what all of the different PC's are running,
I built most of the logic into the triggers. This was the only way I
could see having all of the business logic accessible to everything,
no matter what application (ARC, Access, Filemaker, etc.) was used to
access and modify the data.

-- 
-- Bill Ferguson
--
http://www.freelists.org/webpage/oracle-l

Other related posts: