Re: multi user increment

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

_______________________________________________
WebObjects-dev mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/webobjects-dev