<<I have newly created table with no records, but will grow with time
and then I will need to obtain the last N records added to it, in the
order in which they where added.

I appreciate any solutions or ideas. Currently using FB 1.5.2.>>

How about:

SELECT FIRST N FROM MESA
ORDER BY CREATED DESC

(where "created" is a timestamp column)

?

Clay Shannon,
Dimension 4 Software