| Subject | Re: [firebird-support] How do I read a specific range of records from a table in the database |
|---|---|
| Author | Ann Harrison |
| Post date | 2013-01-22T16:00:28Z |
On Tue, Jan 22, 2013 at 9:18 AM, Rudy Popeszku <rpopeszku@...>wrote:
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.
Good luck,
Ann
[Non-text portions of this message have been removed]
> Oh, ok. I wasn�t aware that Firebird re-uses space that way. I need to findIf you use Set's suggestion, you don't need to know anything about the
> out how the data is stored and deleted which is done by another program I
> am
> unfamiliar with.
>
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 awill work too.
> 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
Good luck,
Ann
[Non-text portions of this message have been removed]