Nice post, Eric!
>
>The answer is to make the primary key assigning part of the stored procedures of the database. SQL Server does with a datatype called IDENTITY, which is an automatically auto-incremented integer field.
>
And if you're backend store is Oracle, look at Sequences.....which are maintained in Oracle system tables and assigned via (if I recall) assignment of a column to a domain.
And if you're in SQL7, there is a new datatype called "uniqueidentifier" which will assign GUIDs....
My .02 to an already well-thought out post :)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05