Thanks Lester

Sorry about the delay I only just got your email. My list groups are
about 6hrs behind today!

Thanks exactly what I wanted to hear.

Rob Martin
Software Engineer

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

Wild Software Ltd



Lester Caine wrote:

>Robert martin wrote:
>
>
>
>>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?
>>
>>
>
>As long as you do not have 'FetchAll' set then yes.
>
>
>
>>I have a query that returns 100,000 + records but normally only the
>>first 100 or so would be of any interest.
>>
>>
>
>It depends on what you are doing, if you only display the first 10 or so
>records, then scroll down a few pages, then only those records will be
>pulled in. But if you do something that needs to see all the records ...
>
>If you know you only want a subset of data, then the SELECT FIRST X SKIP
>Y can still be slotted in, but in simple cases, IBO will take care of
>everything.
>
>
>