Subject Re: Is some API to get generator value?
Author emb_blaster
> >  Also, I can agree that seems make no sense at all that. But I've learned to do not call stupid something I did not understand at all. Maybe in the time it was made, a "no transaction request" would make no sense too.
> > So, if someone else could explain, I would be glad to learn too. But don't think this is a bug or a missing feature at all. :)
> >
> Since you can neither write nor read the contents of the database
> without an open
> transaction, it may be that the designers assumed that there would be
> a transaction
> started or about to start when someone wanted the current contents of
> a generator.

I said it had to make sense. :)

> Note that in a multi-user application, the value returned by GEN_ID
> (<generator>,0)
> may well not be the value most recently stored by the transaction that
> gets the value.

that I wasn't aware... need research more about... o.o''

> Good luck,
> Ann

Thanks Ann. I love your kind, simple and yet thoughtful replies.