On 18 Jan 2002, at 14:13, alex_vnru wrote:

> JO> Q1 will return the number of records that existed at the start of
> JO> the query
> JO> process. Anything added after the start would not be included.
> JO> IB will grab
> JO> transaction numbers used for determining the correct records at
> JO> the beginning of
> JO> the query. Q2 has not committed its data at that time so its
> JO> transaction ID
> JO> will not be considered.
>
> I quote Jeff as English-speaking man to don't add more confusion
> to this already confused subject by my barbaric English.

Jeff is right for "snapshot" transactions. But read committed reads
"newer" records as they are encountered during natural scan.

Best regards

Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information