Martijn Tonies schrieb:

>
> > > Hmm - can't read that from your query ( select * :-)
> >
> > Why?
> > It was: SELECT FIRST 100 * ....
>
> Doesn't this ask for data from DISCS as well??

Good question.

If you do this with IBExpert you get 100 records back (as I expected)
but if you ask for record count you get the total ;-)

The same goes for IB_SQL.

Haven't tested it with DBWorkbench, since I didn't win a copy in Fulda
;-)


Luc.