19.12.2017 16:34, Nico Speleers nico.speleers@... [firebird-support] wrote:

> I want to know the next Id number in my table Addresses without an insert. In my example
> it will be 3. I want to reserve (without an insert) Id number 3 because someone else can
> also ask the next Id number. In that case it must be id number = 4, because you've got
> Number 1 and 2 in the table and number 3 is reserved.
>
> How can I do that ?

Use sequence.


--
WBR, SD.