25.06.2014 12:41, Roman Simakov wrote: > The same prepared query can re-read fresh data in the same > transaction, for instance refresh number of books.
You'll be wondered, perhaps, but a prepared query can re-read fresh data in any transaction, not only in one where it was prepared. > But read commited transaction can see new data. Newly started concurency-level transaction can do it as well. -- WBR, SD. ------------------------------------------------------------------------------ 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