| Subject | Re: [firebird-support] Is there a way to tell the order that rows were inserted? |
|---|---|
| Author | Lester Caine |
| Post date | 2004-08-17T14:41:53Z |
Bob Murdoch wrote:
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
> I have a need to know the order in which the rows were inserted. WillBest it could do is when last updated, but it does not have any order.
> rdb$db_key allow me to ascertain the 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