Author Woody
6bf$50952200$a081ffcc@popstoy> <3B61A571.17A94FA@...>
Subject: Re: [ib-support] Deadlock and wait
Date: Fri, 27 Jul 2001 12:39:02 -0500
MIME-Version: 1.0
Content-Type: text/plain;
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200

From: "Robert F. Tulloch" <tultalk@...>
Sent: Friday, July 27, 2001 12:31 PM
> Sounds cool. My PK's are Id's, not not necessarily continuous. I don't
use gen by my
> own thing to get next sequential or fill in missing values where they have
> deleted.

The nice thing about using MIN and MAX is that:
1. The PK doesn't need to be continuous. It can skip values. (Like when
deleting records)
2. It works with char fields as well as numeric so you can use it for
almost anything.