Murray Brown
asked on
VB.net 2010
Hi
I need to generate a unique ID eg 56776. What VB code do I use and how do I make sure that it isn't entered twice
I need to generate a unique ID eg 56776. What VB code do I use and how do I make sure that it isn't entered twice
Describe the context as well. Is it for a primary field in DB? Why not use an Identity field? Or you can use a GUID
Explain your requirement properly.or the context in which you need this.Making Id field primary key is enough to check duplicates
Describe the context. You can use this:
Dim ID_Field As Guid = Guid.NewGuid()
ASKER
Hi
It is not a primary key. I am recreating an adapted version of Pastal Accounting and there is a transactionID which is secondry to the main ID field
It is not a primary key. I am recreating an adapted version of Pastal Accounting and there is a transactionID which is secondry to the main ID field
Would a random number work? Or does the number need to be in sequence?
ASKER
the number needs to be in sequence
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thanks