Subject RE: [firebird-support] How do I read a specific range of records from a table in the database
Author Rudy Popeszku

-----Original Message-----
[] On Behalf Of Ann Harrison
Sent: Tuesday, January 22, 2013 10:00 AM
Subject: Re: [firebird-support] How do I read a specific range of records
from a table in the database

On Tue, Jan 22, 2013 at 9:18 AM, Rudy Popeszku

> 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]



Visit and click the Resources item on the main
(top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links