Is there a way to atomically set a NextValue counter if the current value is lower than some specified value? This could also take the form of GetNextSequence(seqName, minValue). There doesn’t seem to be a way to do this atomically, so any attempt to do this within a BPM creates a race condition.

How about this? var nv = new NextValue(Db); int foo; while ((foo = nv.GetNextSequence("FOO")) < MIN) { Console.WriteLine(foo); } GetNextSequence() will get the next value and rev the counter so no one else can get the same value. I think that satisfies your atomic requirements. As far as the …

Atomically setting NextValue counter?

Epicor ERP 10

TobyLai (Toby Lai) December 18, 2019, 2:53am 2

I guess you mean Automatically?

I think your solution is related to this post.

2 Likes

Topic		Replies	Views
Atomically updating UD01 counters Epicor ERP 10 bpm	4	770	August 22, 2019
Auto Numbering - Customer ID Epicor ERP 10	100	33315	August 15, 2024
Check if a NextValue sequence exists? Epicor ERP 10 e10	0	582	February 5, 2020
NextValue API and REST Epicor ERP 10 e10	1	766	December 12, 2020
Reset Sequence Number Monthly and Automatically Epicor ERP 10 epicor , bpm	0	660	April 5, 2022

Atomically setting NextValue counter?

Related Topics