Subject Re: Locking tables or dirty read
Author Svein Erling
Hi Alexander, take a look at

I don't know whether "An Auditable Series of Numbers" helps you or

--- In, "a_broekhuis" <akhorahil@h...
> wrote:
> > store your fixed key values in a small table and use a select
> statement in
> > your trigger to get it and combine it into your key
> Getting the fixed key isn't a problem, the problem is that I don't
> know how to raise the second part of the key. It needs to increment
> that part depending on the fixed key.