Hi Naomi,

>I agree with Jim. If you want to use FLUSH use it after End transaction. Now, the problem could be if you use nested transactions (as in MereMortals framework parent-child biz objects). In this case you would need FLUSH only in the top most object. That's why I abandoned the idea of using FLUSH at all.

I'm probably going to modify my update routines/classes to use a switchable Flush Force after the transaction for each table in the transaction.

Thanks for the feedback

Malc