On 24-6-2014 17:53, Paul Beach wrote: > > <<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.
Or do what Microsoft did: you can configure a SQL Server database to use READ COMMITTED SNAPSHOT as the default when READ COMMITTED is used. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ 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