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

Ciao,


Best regards,
Application Developer
Calin Iancu, Pirtea
S.C. SoftScape S.R.L.
pcalin@...