• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: multi user increment
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: multi user increment


  • Subject: Re: multi user increment
  • From: Guido Neitzer <email@hidden>
  • Date: Mon, 6 Feb 2006 16:32:46 +0100

On 06.02.2006, at 16:08 Uhr, Helge Staedtler wrote:

hmm, I would have a look at the primary keys.
those are ensured by EOF and the DB to be unique, so any number which is
derived from the primarykey (you might e.g. transform an alphanumeric PK
into a pure number key) should meet your criteria.

No. Primary keys are not guaranteed to be in sequence without "holes". You may use a stored procedure or something like that to increment a counter - beware of rollbacks.


If there is no requirement for a real sequence without holes, pk may work. Or, depending on the database, any mechanism that can be used for integer pk generation.

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development


Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: multi user increment
      • From: Helge Staedtler <email@hidden>
    • Re: multi user increment
      • From: Gino Pacitti <email@hidden>
References: 
 >Re: multi user increment (From: Helge Staedtler <email@hidden>)

  • Prev by Date: Re: multi user increment
  • Next by Date: Re: multi user increment
  • Previous by thread: Re: multi user increment
  • Next by thread: Re: multi user increment
  • Index(es):
    • Date
    • Thread