On 13/12/2019 19:07, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Is <timestamp> a field I create, or is it part of all records?
It is a field you create. Which is why I wrote "Where <table> is the table in question, and <timestamp> is a suitable column (eg a timestamp) to determine what the newest record is." You might be able to use the pseudo-column RDB$RECORD_VERSION, but that is not necessarily in the right order of recency, because the value is the transaction-number that wrote the last version of the record. This means that updates to a record will also make it 'recent' and a record written by a long-running transaction might not show up as 'recent' (or at least as older than it may actually be). Mark -- Mark Rotteveel