Skip to Content
0

How to generate unique incremental number (series) using SDK?

Apr 21 at 01:09 PM

63

avatar image
Former Member

Hi,

I have a UDO that contains a user field "member number" that needs to be unique and incremental. What is the best way to generate a unique number and make sure it is not duplicated?

I'm currently thinking of creating a user defined table and using the value of Code for this series.

This UDT will have a field named guid, and whenever I need to generate a member number I add a new record in this table with a newly generated GUID. And then search for the record with this GUID and return the Code.

Is there a better way of achieving this result, that I'm not aware of?

Thanks,

Osama

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Apr 23 at 05:53 AM
0

Hi Osama,

Please have a look at the answer I posted to this similar question.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
Ranu Vijay Apr 28 at 07:07 AM
0

Hi

Use fms to increment values of required field, let document number be the criteria to have incremented values.

Thanks

Share
10 |10000 characters needed characters left characters exceeded