Help Saving Updated Fields - Budget test

Wed, 03 Mar 2010 18:16:45 GMT

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 ..

topic Help Saving Updated Fields - Budget test in QlikView

Help Saving Updated Fields - Budget test