Mercea Paul wrote:

> If you never delete records from this table, you can use a generator to
> increment rowid !
>

And if you do delete, you can decrement the generator - but be aware
that generators are not transactional, so rolled-back inserts and
deletes will be counted.

Cheers,

Ann