On 8/23/12 1:09 PM, Lew Schwartz wrote: > Unless speed is of the utmost importance, I've used > > select max(idno)+1 as idno from target into cursor nextkey > > to get the next value.
Sorry, but I disagree. You'd have to do this inside a locking mechanism, unless you are only talking about a single user. How is using an integer simpler than using a random, virtually guaranteed to be unique string? > The problem with autoincrement is that can be very time consuming to fix > after a system crash. The problem with autoincrement is that you are relying on an opaque algorithm. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
