Thanks, I tried rows and it does the trick.

Rudy



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
Sent: Tuesday, January 22, 2013 2:06 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 Mon, 21 Jan 2013 15:45:54 -0500, Ann Harrison aharrison@... <mailto:aharrison%40ibphoenix.com> >
wrote:

> On Mon, Jan 21, 2013 at 2:59 PM, HotRodRudy rpopeszku@... <mailto:rpopeszku%40aps-tech.com> >

wrote:

>
>> Support,
>>
>> I am using Firebird server 2.5.2, Windows 7, and Visual Basic 2010.
>>
>> I would like to read a certain # of records from a table in the

database

>> using a start / stop record range. I am trying to re-write an

application

>> written by someone else which reads the entire database from beginning

to

>> end which takes a long time and I may only need the last 1000 records

of

>> a
>> database that can have over 100,000.
>
> You can using something like SELECT FIRST FROM

tables and conditions>

You can also use ROWS:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-select.html#langrefupd25-select-rows

Mark





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