>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.
Doug
Remember not to use certain commands in transactions -- look in Help. TableRevert() is one of them. Remember a transaction is a buffer. When you TableUpdate() you copy to the second buffer -- the Transaction buffer. If you RollBack 'then' you need to TableRevert() (after the Rollback!!!)
Just remember you are working with two sets of Buffers. Try and keep your buffers straight.
HTH,
Tom