Please list the PK generation routine. There is probably something wrong in this algorithm.

Walter,



>We've got some pretty tight primary key generation code in our program. We've got about 400 customers of various sizes using it with NO problems. ONE particular company (largest customer, uses a Citrix farm instead of individual workstations) keeps on getting duplicate primary keys. Sometimes the keys will SKIP over several before duplicating. For example:
>
>24210
>24211
>24212
>24210
>
>Or sometimes they'll be right next to each other. We are using VFP6 SP4 (Yea, we are working on going to 8). It SEEMS like it's one particular user that's creating most of the duplicates, but we can't tell for sure, and since it's a citrix farm, there hsouldn't be anything "different" about her PC. We think it may be some sort of cacheing problems.
>
>We are using free standing Foxpro tables, there isn't a database container. And yes, we are working on a SQL version of our program =)
>
>Has anyone else encountered a problem like this? Any thoughts/comments/solutions?
>
>Thanks,