>I have a need to monitor the status of a logical field in a table and if it switches I need to send an email. A good place to do this would be a table trigger but then I have to depend on the application object and smtp object being available and I'm not sure that it is proper to put such calls in a trigger. Is it generally acceptable to do such a thing?
In n-tier application this probably should go into business logic tier.
However, from VFP trigger I think it's acceptable. But this is just my opinion.
If it's not broken, fix it until it is.
My Blog