Hi John,
I've heard you mention the sys(2015) before for UIDs, however you seem to be one of the few people using it. Or am I mistaken and most people use it.
I was thinking fo switching over to that and dumping my NextKey function that uses a table.
>Jeez, this sure has generated a lot of messages.....
>
>My take: I'm with the surrogate key crowd. I don't reuse crap. I either use some variation on SYS(0)+SYS(2015) or a GUID and fuggedaboudit.
>
>Even SQL Server is going this way, hence the uniqueidentifier (which is a GUID) in addition to the identity (integer).
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!