>Can anybody certify that the SYS(2015) function is generating unique ID. I plan to use this as a primary key in a big system and I want to be sure it won't generate duplicate...
At least, I never heard of anybody trying to use it as a PK.
Let's see some solutions other people use for PKs.
How big is your system? If there are several computers connected over a single network, you might consider storing the next PK value in a table. (Integer; 4 bytes.)
For disconnected systems, some people use GUID. This one is guaranteed to be unique for machines that have network cards, and very unlikely to have duplicates for those that don't. (16 bytes.)
Another option is to assign an ID to each user (machine), and combine it with the first solution I presented. (6 bytes, if you use bintoc(User_id, 2) + bintoc(serialnumber(...))).
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
