>>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.

Yep, I have to go through a little red tape for dbc changes. So put in quick fix for this week.

Thanks
Jeff