Write a stored procedure to generate it in the DB, triggered on insert. Slap a unique constraint on column, catch exception and deal with.
If you need this number in your EOF stack, don't forget to setRefreshesFetchedObjects on the fetchspec (or something like that).
Might work...
Geoff
On 06/02/06, Gino Pacitti <[EMAIL PROTECTED]> wrote:
Hi All
Any thoughts on how to address this problem
I have a multi instance app that connects to a single data store.
For any user, across the instances, I need to increment a numerical
value newly for each new registered user.
This then has to be saved back to the data store and for there to be
no conflicts with similar values for new registrants...
Any ideas or have I missed something easy here..
Gino
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/geoff.hopson%40gmail.com
This email sent to [EMAIL PROTECTED]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
