>>Question came up on Darcy Whites listserv and thought I'd throw it around here.
>>
>>What is best way to generate a new primary key?
>>
>>I use a udf that stores the pointer, and order. Then sets the order to the primary tag, then goes bottom and increments, then returns order and pointer and returns back new key. Fairly fast udf since it doesn't do any locate etc but if anyone has better code/ideas let me know.
>
>what I do , which is btw, a la codebook - is use a table that holds (among other things) the last primerykey value of each table and get new PK using this table
>
>Arnon
Now why didn't I think of this. What a great idea. Sometimes its the simple solutions that are the most elusive.