DB

Hi, 

I see from a few posts way back that some have tried this through various different guises - but ....

We are attempting to implement an auto incrementing ID for the models/objects etc. This is a number that never changes ( similar to GUID ), but rather than give out the GUID to other business users, a simple number - without logic - that can be used as a "birth certificate - number". Even if it moves around the hierarchy, the number never changes.



I see that by placing a tick in the "Assigning Identifiers when creating new database items" under the DB properties this actually turns on the functionality that is needed, however I need to be able to set the starting point of the Identifier that is used. 



Is this something that can be achieved with SetSequenceNumber(num) ? 

If so, has anyone ever tried it, and succeeded?

If not, can I access the RDBMS to increment this identity?

Any thoughts, anyone, please ..... ?

 

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock