I am getting datasessions that stick around (Unknown(2) etc...) when a form closes after triggers have fired for code generated by the RI Builder.

I am wrapping my TABLEUPDATES() within a transaction. If I comment out my BEGIN TRANSACTION, ROLLBACK and END TRANSACTION statements, the problem doesn't occur. The RI code is also using transactions and I don't know if this is causing the problem somehow.

If anyone has any ideas or suggestions, I would appreciate any help.

Also, if anyone has comments on using the RI Builder to create the RI code, please post.

TIA!

-Doug-