Re: sequential numbering across more instances
Re: sequential numbering across more instances
- Subject: Re: sequential numbering across more instances
- From: Chuck Hill <email@hidden>
- Date: Wed, 20 Aug 2008 09:40:01 -0700
Hi Cail,
On Aug 20, 2008, at 6:47 AM, Cail Borrell wrote:
Hi Ondra,
If you change the internal data type of your unique attribute to
String
you should be able to use a little sql injection when inserting your
record.
Just set the value of your unique column to something like:
coalesce (select max(<unique column>) from <table name>, cast
(1000000 as <unique column data type>)) + 1
That won't work, will it? The FB plugin will wrap it in quotes so
this will get inserted as a literal value. Or am I missing some
aspect of your suggestion?
Chuck
and invalidate the eo after insertion.
Looks like the best solution; the only drawback in my case is that
FrontBase needs to be launched with a special option to support
triggers: I can very much see the "why does it not work" problems
at client's, caused by wrong setup here :)
In the latest versions of FrontBase triggers are enabled by default.
-Cail
On 16/08/2008, at 03.03, Ondřej Čada wrote:
Alan,
On Aug 16, 2008, at 2:47 AM, Alan Ward wrote:
That would do it, yes. Have EOF insert the record with a null
value in the column
Actually, rather with some specific non-null placeholder, for there
are records which have valid NULL there.
and use a trigger (after insert) to assign the value from a
sequence.
... if and only if there is the placeholder.
Be aware though that you should not lock on that column or else
you'll run into optimistic locking failures if you subsequently
update any other column before refetching the (now modified) EO.
Yup, that Chuck has pointed out to me at the very beginning, when
triggers were mentioned the first time.
Looks like the best solution; the only drawback in my case is that
FrontBase needs to be launched with a special option to support
triggers: I can very much see the "why does it not work" problems
at client's, caused by wrong setup here :)
Still, all the other solutions look more complex/more error-prone.
Best,
---
Ondra Čada
OCSoftware: email@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc
_______________________________________________
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
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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