I've written a trigger in version 7 which updates an order header table column after an order detail table record is added. I couldn't understand why it wasn't working so I used the SQL profiler to trace the events and found this: the trigger is updating the order header column correctly, THEN the order header is updated with an sp_execute statement where the original, pre-trigger column value is written back, leaving me with a useless trigger.
Is this a SQL issue or a bug in my software (Macola)? Is there something I can do within the existing trigger to work around this? Any help is appreciated.