Subject Re: [firebird-support] How do I read a specific range of records from a table in the database
Author Ann Harrison
On Tue, Jan 22, 2013 at 9:18 AM, Rudy Popeszku <rpopeszku@...>wrote:

> Oh, ok. I wasn�t aware that Firebird re-uses space that way. I need to find
> out how the data is stored and deleted which is done by another program I
> am
> unfamiliar with.

If you use Set's suggestion, you don't need to know anything about the
program that stores data. His trigger will automatically add a value that
indicates the storage order. Create a generator so you have a cheap source
of unique values that suggest the order of record storage. Use a value
from the generator to populate the indicator field and be sure to have a
descending index on that field.

Unless you use "SELECT *", the new field will be invisible to other
applications. If you do use "SELECT *", then you may need to change
things, but that depends on the interface your applications use.

> I only have access to a test database for my development. There is a
> date/time field in the table I am trying to use so I can ORDER BY that
> field.
> Assuming that field is related to the storage time of the records, that
will work too.

Good luck,


[Non-text portions of this message have been removed]