Hi Hans

Sorry, I should have said in my original email that I knew about the
'Select first x' syntax. I actually want all data available, but just
want to know that IBO wasn't going to suck it down until required :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Hans wrote:

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