RE: Get/Calculate the next transaction number (TRNNO) in TRDATA

Peter,
Put a tag immediately above "GET NEXT AVAILABLE TRANSACTION NUMBER".  Then
on the OUT statement add an indicator in the LO field (positions 56 & 57).
The next statement should test if your indicator is *ON, if it is then GOTO
TAG statement.  Somehow the save-while-active interrupts this IN/OUT loop
and we have had dupes for 4 years until our programmer Donald Moody figured
this out.  I must say it really isn't MAPICS fault that the IN/OUT loop and
save-while-active don't work together and they are both IBM
responsibilities.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Peter Vidal
Sent: Friday, May 09, 2003 3:12 PM
To: MAPICS ERP System Discussion
Subject: RE: Get/Calculate the next transaction number (TRNNO) in TRDATA



"It is in ZNXTRN data area - but be careful, MAPICS code doesn't test if
locked correctly and you can end up with duplicate transaction numbers.
(happens during a save-while-active backup)."

Yeap, that is our case Ann.  We do save while active... hmmm... do you have
any
recommendations?

Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com / 727-539-8448, x2414

"A good player makes himself look good;
a great player makes the team look good."
Author unknown


_______________________________________________
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.cgi/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.