Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help Saving Updated Fields - Budget test

Hi all,
i need a little help for a test Budget.

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;


-----------------------------------------------------------------

MACRO:

' 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


------------------------------------------------------------

The last thing, if i set

inputfield BudgetCostPrice;

This Break the update macro, and it produce an Out Of memory ..

0 Replies