Next Transaction #

Chris Kelleher

Administrator
Staff member
Hi all,

I am trying to write a custom program that requires to write transaction
history records. I would like to know where I should update the last
transaction number from tr_hist table in the mfg/pro database. I know that
mfg/pro uses the sequences table from the metaschema but the program that
update the sequences calls a different table that contains the last
transaction # earlier versions had it in the icc_ctrl file. But in the 8.5x
versions sequences are being used. MFG/PRO version 8.5F and Progress 8.2b.

Thanks in advance for any help.

Regards,
Biju

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
 

Chris Kelleher

Administrator
Staff member
You'll want to use the sequence named tr_sq01.

Look at Progress help for CURRENT-VALUE and NEXT-VALUE to be used when
working with sequences.

Also, look at mfntran.i - you'll probably want to use this include instead
of directly using the sequence.

- Tris Hopkins
Flexalloy-Textron
 
Top