I like random, unique strings too. Incrementing integers give a chronological footprint which is sometimes interesting or useful.
-Lew Schwartz On Aug 23, 2012 4:25 PM, "Paul McNett" <p...@ulmcnett.com> wrote: > 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 > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/CAFuU78f1W7NCWAQzdELDj0aG0BLj=xcee-enth3ckfg3prf...@mail.gmail.com ** 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.
