Adam wrote:

> SNAPSHOT/CONCURRENCY = Repeatable read

Thanks a lot for this.

> Not sure where the terms came from, but remember that Firebird's
> predecessor predates SQL92, so it would not surprise me if the terms
> are slightly different.
>
> The document I posted before mentions the way the levels are in Firebird.

Yes, I failed notice these because I've brain-washed by the odbc transaction model.

> http://www.dotnetfirebird.org/transaction-isolation-levels

Good, this explains the details in terms of the sql-92 model. It also mentions
read-uncommitted can be emulated in Firebird. although not a true
"read-uncommitted" but who cares the difference if dirty-read is expected.

Thanks for help, again.

regards,
bill