--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Maybe there's a way to execute code on commit that would

atomicaly

> > 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.