×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
MVC is an application development architecture. DB providers could really care less how you application works. They just provide the data.
However, MOST MVC structured applications use triggers and constraints. In fact, some may argue that you should move as much of your Model (business rules/validations) into the database layer as possible.
Along those same lines, the DB should have no direct link to your View layer. So your triggers and constraints should just issue errors that your Control layer will interpret and deal with.
Brian May
IBM i Modernization Specialist
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free
Modernization Made Easy!
www.profoundlogic.com
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin
Sent: Monday, September 22, 2014 1:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: Anyone using Triggers to enforce data validation & business rules?
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.
midrange.com
