Here is how I am trying to update a value to be a custom value from the CostingVersion Table. This control does not contain a datasource. It is a method that runs off the form BOMCalcDialog. It is getting the correct information but when I test the code. It doesn't change to what is expected. It shows 1 not 5 which is what variable "qty" equals. Why isn't it committing the change and displaying 5 on the form instead?
public static void BOMCalcDialog_OnInitialized(xFormRun sender, FormEventArgs e)
FormRealControl itemqty = sender.design().controlName("itemQty");
FormStringControl costVer = sender.design().controlName("VersionId");
str version = costVer.valueStr();
select * from costingVersion
where costingVersion.VersionId == version;
ProductQuantity qty = costingVersion.MJMChargesQty;
Doesn't it simply mean that the value is overwritten later?
By the way, you can greatly simplify your code with CoC. You should be able to write something like this: