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