sgoupil
3rd November 2010, 16:26
Hi all,
I hope some of you expert could light me up here.
In the past (before I got here) somebody added a field to table tdinv310 (INV Planned Purchase Orders). This field is a Confirmed Date field, it has been added to the form so user can manually update that field. No other session do an update on that field, only manual, of course no other logic on it (we do not own the code).
My problem is that when running session tdinv3201m000 to generate the INV Planned Purchase Orders, order get recreated, order numbers changes but magically, the Confirmed Date field comes back with the old value. I would expect it to come back blank. I saw the code, it does delete the selected records in the table and then insert records back in it. The only thing I could think, is that for the whole transactions (delete, then after insert), there is only 1 commit at the end, but I'm not sure how this would put back the Confirmed Date on the new records created (with a new order number!). We checked, there are no triggers on that table!
If you have any idea, thanks a lot.
Sylvain
I hope some of you expert could light me up here.
In the past (before I got here) somebody added a field to table tdinv310 (INV Planned Purchase Orders). This field is a Confirmed Date field, it has been added to the form so user can manually update that field. No other session do an update on that field, only manual, of course no other logic on it (we do not own the code).
My problem is that when running session tdinv3201m000 to generate the INV Planned Purchase Orders, order get recreated, order numbers changes but magically, the Confirmed Date field comes back with the old value. I would expect it to come back blank. I saw the code, it does delete the selected records in the table and then insert records back in it. The only thing I could think, is that for the whole transactions (delete, then after insert), there is only 1 commit at the end, but I'm not sure how this would put back the Confirmed Date on the new records created (with a new order number!). We checked, there are no triggers on that table!
If you have any idea, thanks a lot.
Sylvain