I would like to "SAVE" the modified Budget Field because when i reload the budget field change to the original values. I Have thinked about a Button "Save" ad a second "Reset"...
but i don't know how to save changed values..
LOAD SCRIPT:
Products_tmp:Load * INLINE [ProductID,CostPrice1,102,203,304,40];Products:Load *,CostPrice As BudgetCostPriceRESIDENT Products_tmp;DROP TABLE Products_tmp;
' Provide the selected record Updatesub modNewCost2 dim strVal,strValIDprodotto ' New record Value SET objSource = ActiveDocument.Variables("vNewCost2") srtVal = objSource.GetContent.String ' New Value SET recProdotto = ActiveDocument.Variables("IDprodotto") recProdotto = recProdotto.GetContent.String ' UPDATE query="UPDATE Products SET BudgetCostPrice="& srtVal & " WHERE ProductID='"& recProdotto &"'" set sqlerror=ActiveDocument.DynamicUpdateCommand(query) if (sqlerror = false) then ' send message when error MsgBox sqlerror.ErrorMessage exit sub end if end sub' Save data..incompletesub salva set v = ActiveDocument.GetVariable("SALVA") v.SetContent "1",trueend sub