Leon, try

select first 10 name, adress from customers order by name

(i.e. omit brackets and add an order by clause)

It doesn't make much sense to just select the first 10 without any order by
clause. Anyway, you may have found a kind of bug, but if it had been a
known bug due to IBO, I'm pretty certain Jason would have fixed it!

Set

>select first(10) name,adress from customers
>
>Using IBOquery
>I get 10 records if "fetchwholerows = true" but I get 20000 records
>if "fetchwholerows = false"
>
>So is this a known IBO-bug, or is it just me ?