>I am using the sys(3) function to assist in generating unique id's. I have over 300 clients using this functionality without a problem. However, I recently had a client who was receiving duplicate id's. There problem was fixed by replacing the computer. I now have another client with the identical problem and they are not willing to accept that their computer is to blame.
>
>Has anyone ever seen this kind of problem before. The problem is not related to CPU speed since the id is only generated per request and it would be impossible to input requests that quickly.
>
>Any help would be greatly appreciated.

David,

This si not a problem with the clients computer, it si a weakness of SYS(3). SYS(3) can create duplicate values, and because of that you shuld rewrite your code to find another way of generating your unique IDs. Using a next ID table is a very solid way of doing this.

The two out of 300 is in line with the frequency that SYS(3) messes up. If you choose to continue to use SYS(3) you are only asking for more trouble down the road.