Subject Re: [firebird-support] Is there a way to tell the order that rows were inserted?
Author Lester Caine
Bob Murdoch wrote:

> I have a need to know the order in which the rows were inserted. Will
> rdb$db_key allow me to ascertain the order?

Best it could do is when last updated, but it does not have any order.
Next record goes in the next available slot, how ever it was created,
when a record is updated, a new one is created, and after commit, the
old one can be deleted, so an earlier slot will be used again with a
later record.

You needed the timestamp field from day one.

Lester Caine
L.S.Caine Electronic Services