benno wrote:

> Milan,
>
> I guess this is one way to do the autonumber thing. But in your solution you
> keep an update transaction open the entire time of the action. I am no
> expert but I guess an update or insert transaction should be as short as
> possible.

Actually, it is. The code as example in previous post, is inside the SP
that does all inserts.

> But as told in my other mail there is an excelent article on the site of
> IBobjects on this subject. Also Helen has given some advice on this in the
> past (just view old messages).

Read those. I just wanted to give another example of doing it.

Milan Babuskov