Thanks

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Tuesday, January 22, 2013 10:00 AM
To: firebird-support@yahoogroups.com
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
<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,

Ann


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



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the main
(top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links