I am trying to finally incorporate one of my long time wishes by using a Data Directive
When a Transaction occurs in the PartTran table that matches a set of conditions, I want to update a User field in the Part table
I created an In-Transaction data directive and added a condition element. I then added an execute code block and set about updating the part table.
When I execute a transaction that should update the Part field, I receive this Server Error:
The object cannot be attached because it is already in the object context. An object can only be reattached when it is in an unchanged state.
I disconnected the execute code block and added a information message - The message gets displayed 3 times (I have to click OK 3 times)
Is this the cause of the Server Exception?
Any way to fix it so it does what I want?
Thanks,
bw