Subject Re: Complex generators?
Author ivoras
--- In, "Alan McDonald" <alan@m...>
> > Maybe there's a way to execute code on commit that would
> > update the ID field?
> >
> No there isn't...
> Your client starts the transaction and issues a commit. There is
no trigger
> at the server "onCommit".
> I think you're barking up the wrong tree here. You must come to
terms with
> multi-generational, multi-user and transaction controlled
environments in
> your model if you are going to make this work for you.

I don't see why that cannot be reconciled with what I was talking
about, but then I don't know much :)

> You may need to talk more about your real task at hand - maybe
there are
> other solutions for what you are trying to do.

It is really that simple - an user has to enter records of
transactions (acually, something like a sales bill), that is of a
certain type ("TYPE" field), and for legislative reasons the
sequence numbers (the "ID" field) must be sequential, and resilient
to multi-user input problems. I'm using Delphi 7 and Firebird 1.0.3.