Re: Updating PO Item and Release files

1)  We use a lot of triggers and can't do without but be careful they do
affect system performance.

Vince 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Sansi, Jim
Sent: Thursday, March 01, 2007 1:19 PM
To: MAPICS ERP System Discussion
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.