maybe

select first 100 * from table

will satisfy your requirements ?

----- Original Message -----
From: "Robert martin" <rob@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 07, 2005 2:56 PM
Subject: [IBO] IOBQuery


>
> Hi All
>
> Am I right in saying that when a query is run only a certain amount of
> data is transfered from the client machine to the server? Is this
> configurable, if so where?
>
> I have a query that returns 100,000 + records but normally only the
> first 100 or so would be of any interest.
>
>
> --
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>