HB> *The transaction that his procedure runs in* (call it
HB> ThisTransaction) indeed DOES read the uncommitted inserts that its
HB> statements have executed. A transaction sees all of its own work.
HB> Have you been handling this hot thing all this time, without knowing? ;-)

Ouch! I surely knew. After all it's in your book, and I made sure to understand all that before I bet our company's fortune on a new database.
Funny... when rereading this now (pp 529/530) I even found that I underlined it to keep in mind better, which was somewhat futile, obviously :-)

For me, a transaction inserting something and then reading it again in the same context is somehow alien. But I realize that it might be just normal or probably even desirable by others.

Thanks Mark, Helen and Ann for setting this right; won't forget it for the next 2 years or so :)





HB> ------------------------------------

HB> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

HB> Visit http://www.firebirdsql.org and click the Resources item
HB> on the main (top) menu. Try Knowledgebase and FAQ links !

HB> Also search the knowledgebases at http://www.ibphoenix.com

HB> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
HB> Yahoo! Groups Links



---