Re: Anyone using Triggers to enforce data validation & business rules?

Sure, in the sense that if your using MVC, there's only only place to
handle the error (Model) and you've already built some sort of error
passing mechanism that you can make use of.

Check out the error handling in Scott's MVC article
http://iprodeveloper.com/rpg-programming/pattern-recognition-ease-modern-rpg-programming

Charles

On Mon, Sep 22, 2014 at 2:58 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

Along that line of thinking... don't other database providers suggest
that data never be accessed directly; that we use
/Model/-/View/-/Controller/ (/MVC/) to work with our data? Does that
scenario provide an answer that can be adapted to solve this problem?


On 9/22/2014 1:18 PM, Charles Wilt wrote:

I think it's a bad idea to have the trigger program attempt to display any
kind of UI...

If your looking for quick & dirty...I'd have the trigger program fix the
issue if possible or allow the "wrong" value while logging and notifying
somebody about it.


Charles

--
Booth Martin
www.martinvt.com
(802)461-5349
Skype: booth.martin

We have the best government that money can buy. -- Mark Twain

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.