> Don't do that. It doesn't work multi-user. Let me say that
> again - assigning identifiers by finding the max identifier currently
> used does not work in Firebird. You'll get duplicates.

not really because every insertion is commited inmediatly.
The value is generated in the before trigger.
posibly duplicates in Therory? YES, Practically? NO.

> Either use a generator or check the archives of this list of
> multi-user safe ways of creating unique identifiers.

Tks Ann, Tks Adam.

In a perfect world will be the solution, but we don't live in.

I can't use a generator for this work, because i need a REAL sucession
without gaps.
REally I use a generator for the REAL PK in the record, unique and
perfect, but for the N_DOc fiel can't use because I need allways a new
value succesor of last, even if last value is deleted...
Even more problems... I use IBO from Delphi, and need to define the
generatos inside the query, and every time I do ans insert, the
generatos is incremented, even if finally I don't do the insertion...

This is why I need a new arround to give the value.
I try the Adam path, think is the best way for my particular case.
I used in a lot of tables the generator solution, and work nice, but
for an "administrative field without gaps" it's not valid.

Tks all ways.