>I've taken over an app that uses sys(2015) to generate values for a candidate key. Users are getting "Unique index violation" errors occacionally and have to re-enter data. I cannot change the data structure to hold more characters.
>
>I'm replacing 2nd and 3rd chars with info from userid, in hopes of greater chance of uniqueness.
>
>Any better ideas for a temporary quick fix?
>
>Much Thanks
>Jeff
Why not just implement a simple key generator? Ie, store the key value in a table, and increment each time it is called.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown