<<But, after reading MS-SQL's read committed isolation level, their default behavior is the same as Firebird's. And, they introduced the READ COMMITTED SNAPSHOT isolation level, which is at the statement level, and that is what Nickolay is looking for. And, both READ COMMITTED isolation levels fall within the SQL Standard.>>
Exactly... we need to keep our default behaviour as is and create a new isolation level that supports the cursor stability in Read Committed that Nikolay wants. Regards Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32 ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel