--- In firebird-support@yahoogroups.com, "pokka_chi" <pokka_chi@...>
wrote:

> I thought so. I have a hypothesis. Perhaps Ann or Helen can

comment.

> I think this might be related to MGA. When FB receives my SQL
> statement (select first 10 * from MY_TABLE where Column1 > 100 order

by

> Column1, Column2), it doesn't use the parameter for FIRST. So it

will

> tag all the 89901 records with my transaction id.

Sorry, I meant "check" rather than "tag". Sometimes, my hand is faster
than my brain.:)

PK