Update Table by Query Widget Troubles

[Chan213419 (Jeremy Chance)]

All I want to do is update ShipHead.Character02 with “Yes” when the user clicks "Shipped’ in Cust Ship Entry, Post-Proc BPM. I Use Invoke BO Method:

Then Update Table by Query:

Query

Configured Mapping:

Save it using Invoke BO:

This setup results in the ShipHead record being deleted entirely… I’ve used this before and it worked fine. Not this one though… No idea why. I ended up using code and it worked just fine, so it being “shipped” didn’t stop the transaction, so why would this fail?

[Chan213419 (Jeremy Chance)]

If you run into this, it’s probably going to save more time to just do it with code instead, which is what I did.

[utaylor (Utah Taylor)]

Would you paste the code for others to learn from?