----- Original Message -----
From: "Pirtea Calin Iancu"
> ----- Original Message -----
> From: "bemmel2003"
>
> > Svein,
> >
> > I know about the "orderby" but first(10), first 10, with or without
> > orderby doesn't change things. It really is caused by "fetchwholerows"
> >
> Just tried this on my system and it has the same problem.
> Delphi5 Pro
> IBO 4.2.Ia
> IBOQuery with fetchwholerows=true works ok
> IBOQuery with fetchwholerows=false works not ok (all rows are fetched)
>
Same thing happens with IB_Query.