Table Trigger testing

[KevinCourtney]

Hello,

One of our programmers is modifying some Table Trigger logic that was created by a previous programmer.

After he put in his changes, he does the ‘Build Table Triggers’. When he executes the application locally that should be triggering his logic, he is not seeing his logic executed.

Before we dig any deeper, I wanted to check and see if there are any other steps involved in testing the Table Trigger logic. Can it be tested locally? Or does it need to be promoted to the Enterprise Server?

Any advice would be appreciated.

Thanks in advance,

Kevin Courtney
Trident Seafoods Corp.

Platform: AS/400
Platform Type: Enterprise Server
Operating Sys: OS/400
Database: DB2/400
Release: OneWorld B733.3
Service Pack: 16

 

[tom_brown]

I have had some success using table triggers for audit logging changes to a
table. I found my changes to triggers worked fine locally, there was no
need to deploy the table anywhere else or even to check it in. Are you sure
it is not running, or could it be that the logic he has added is not
working? Try adding a call to M & D Debug function into the trigger, this
will prove whether your changes are being recognised.

Hope this helps

Tom Brown

OneWorld 7.3.3, NT Servers, Oracle Database

 

[DBohner-(db)]

Kevin,

I have had quite a bit of experience with Table Event Rules (they are not
triggers, by any means). Table Triggers can work outside the scope of JDE
Data Modification... TERS happen internal to JDE... you have to be running a
JDE Application in order for the TER to process. Yes, the OMW Table Design
Aid does call them Table Triggers; but they are not Database Triggers -
thus, those familiar with the beast call them TERs.

It sounds as if your programmer was doing the right thing (providing we are
talking TERs). Modify the TER, build the TER then logoff and back on.
Don't forget the last step.

Also, in order for the build to happen properly, the table cannot be in use
at the time... your build should display an error stating the table was in
use and could not be built.

Let me/us know if you need further.



Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x

 

[KevinCourtney]

Re: RE: Table Trigger testing

Hi,

Thanks to Tom and Daniel for the feedback. When he went to test it yesterday, it worked. So it looks like the key was to "logoff and back on" which Daniel suggested.

Thanks again,

Kevin

 

[crowd_controller]

Hi Kevin,

If it still doesnt work try deleting glbltbl.xdb and glbltbl.ddb files.

Best Rgds..sid

----Original Message Follows----
From: KevinCourtney <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: Table Trigger testing
Date: Thu, 21 Feb 2002 05:42:52 -0800 (PST)

Hello,

One of our programmers is modifying some Table Trigger logic that was
created by a previous programmer.

After he put in his changes, he does the ‘Build Table Triggers’. When he
executes the application locally that should be triggering his logic, he is
not seeing his logic executed.

Before we dig any deeper, I wanted to check and see if there are any other
steps involved in testing the Table Trigger logic. Can it be tested
locally? Or does it need to be promoted to the Enterprise Server?

Any advice would be appreciated.

Thanks in advance,

Kevin Courtney
Trident Seafoods Corp.

Platform: AS/400
Platform Type: Enterprise Server
Operating Sys: OS/400
Database: DB2/400
Release: OneWorld B733.3
Service Pack: 16



--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=29320
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+




\|/ ____ \|/
"@'/ ,. \`@"
/_| \__/ |_\
\__U_/
===================================
Siddhartha Arya
+65-90670625
===================================
In three words I can sum up everything I've learned about life: It goes on
-- Robert Frost