Subject | RE: [firebird-support] Feature request : Generator tables |
---|---|
Author | Alan McDonald |
Post date | 2004-02-20T09:45:03Z |
> Yes, of course. However, there are ways to get around this problem. ForThis is a recipe for disaster me thinks - another user or many users can hit
> example, what I usually do, is first get the generator value and display
> it, using "gen_id(gen_name, 0) + 1", and then, if and when the user
> confirms, I actually increment the generator. This avoids all
> concurrency issues in a simple way. However, this technique isn't
your client code here and be sitting on it waiting for confirmation - they
will all have the same PK value!!
Alan