That looks like its just selecting values from the database, not making any updates. You would want to use an update sql statement to update the value in the database.
Are the pages you are working with generated by eCart? It seems like insert and update pages are generated by DataAssist, not eCart.
No, I´m not using eCart, it´s just a simple update page created with DataAssist and I want to be able to change totals as I update with new changes, but also would like to create totals as I insert a new record.
Like I said this sql statement has been placed inside of Server Behavior, it works, but I have to repead the process twice in order to make the changes to the database.
Am I doing this the wrong way, any ideas on how to resolve this???