Re: Updating PO Item and Release files

Good programming NEVER needs triggers.

Triggers become an undocumented mine field unless you spend more effort to 
control them than the effort of good programming.

Every shop I've every worked with that uses triggers starts out just fine, 
until the lead developer or database administrator leaves.  They take the 
hidden knowledge away with them despite the very best efforts to document them.

For those intent on using them, just ask why triggers are the best(!) solution. 
 My experience is that it is an expedient solution instead of the best 
solution.  Another good test is if you have cascading triggers.  i.e. 1 trigger 
updates a value which then triggers an update of another value and so on and so 
on.

This is what good programs are for.

Some will argue that it is a systems resource issue and that keeping the data 
movement in the database improves performance.  This may be true when measuring 
only the movement of the data.  But the business logic tests need to be 
considered in the formula as well.  When you look at the entire picture of 
requirementsKev, very rarely does the trigger win out over a good, tight 
program.

Kevin Fox

-----Original Message-----

From: "Sansi, Jim" <jsansi@xxxxxxxxxxx>
Sent: Mar 1, 2007 10:18 AM
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] Updating PO Item and Release files

3)  Triggers?

Ok, I know what triggers are... We just haven't needed or used them so
far to date. 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
DaleGindlesperger@xxxxxxxxxxx
Sent: Thursday, March 01, 2007 9:10 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Updating PO Item and Release files






Group....

I know all the advantages of triggers - they have been explained to me
over and over.  But I keep being burned on them with things like Eric
mentioned, and others (difficulty in adding or maintaining them in a
24/7 environment).  Am I being too conservative in my outlook in that I
make every effort to avoid using them, and instead run periodic jobs
(nightly seems to be adequate usually) to examine all the files and take
any necessary actions?

I'd appreciate a brief set of responses as to how many of us are using
triggers, just a personal survey, if I may.

1)  Can't live without triggers - they put sliced bread with butter to
shame!
2)  Use them, they are OK, the pain is pretty well worth it
3)  Triggers?   What are they?

So I don't bury the thread on this, please reply to my direct address.
This is totally unofficial, I'm just scratching a curiosity bone....

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501

dgindles@xxxxxxxxxxx








            "Eric Wolf"

            <eric_a_wolf@hotm

            ail.com>
To 
            Sent by:                  mapics-l@xxxxxxxxxxxx

            mapics-l-bounces@
cc 
            midrange.com


Subject 
                                      Re: [MAPICS-L] Updating PO Item
and 
            03/01/2007 11:52          Release files

            AM





            Please respond to

            MAPICS ERP System

               Discussion

            <mapics-l@midrang

                 e.com>









  Besides having to gain full access to the file, you may want to add
the
  trigger using the MAPICS CAS option.  Even though ITEMBL does not
have any
  current triggers on it in XA R6 (PCM 7412), if they add one and you
have
  yours outside of XA, whenever MAPICS runs the command to remove the
  triggers, yours will be removed, too.

  Then when MAPICS runs the command to add back the triggers, yours
will not
  be added back since it will not be contained in the TRGMST file.  I
ran
  into this problem at one client and it took a while to figure out how
it
  was getting removed.

  Eric

    >
    > > We have a trigger on the itembl file.  I used this
    > > template to setup our
    > > trigger, http://www.pbhall.us/trigger.html
    > >
    > > The hardest part of the trigger program is you must
    > > gain exclusive access
    > > to the file in order to add the trigger.


----------------------------------------------------------------------

  Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a
  month. Intro*Terms
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.



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




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