Re: Updating PO Item and Release files

I have three 'user triggers' on my system:

-  Over IMHIST when a new RP transaction is *inserted to produce a 
'receiving document'
-  Using Browser (Integrator) trigger over a custom file
-  Over TEMGEN --> required by FRx

Same as Dave, I try to avoid the use of Triggers as much as possible.


Antonio Rojas
IT Manager - Senior Aerospace, SSP
(818) 260-2218








DaleGindlesperger@xxxxxxxxxxx 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
03/01/2007 09:09 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
cc

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.