Re: Missing numbers ( was Re: )

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Tom Liotta wrote:
> Beyond that, having a second table that lists all valid keys brings 
> the opportunity for exceptions in a clear fashion in SQL.
>   
Not to beat this horse too terribly, but if you're going to add another 
table, a deleted key table is in many ways a better solution.  It is 
*always* a single SETLL/READ to see if there's a hole, and it's even 
easy in SQL <grin>.  The only downside is it requires an extra write 
when you delete a record and an extra delete when you reuse a deleted key.

Joe