Please help with DynamicUpdateCommand

Fri, 19 Feb 2010 16:37:45 GMT

Please HELP ME with macro.

I'm testig DynamicUpdateCommand
for a Budget application.

I would like to update some fild applying personalized functions.

This is my first test, but it return me a Blank msg box

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

sub enrico

set docprop = ActiveDocument.GetProperties
docprop.EnableDynamicDataUpdate=true
ActiveDocument.SetProperties docprop

SET Result = ActiveDocument.DynamicUpdateCommand("UPDATE Products SET Prezzo=0")
if Result = false then
MsgBox Result.ErrorMessage
else
MsgBox("FATTO")
end if
ActiveDocument.Save
end sub

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

The load script:

Inputfield Prezzo;
Inputfield Quantita;

products:
LOAD Prodotto,
Prezzo,
Quantita
FROM
sorgente_test_frutta.xlsx
(ooxml, embedded labels, table is Foglio1);

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

Where is the error ?

What is the best way for top->bottom
or bottom->top functions ?

Thanks

Enrico

topic Please help with DynamicUpdateCommand in QlikView

Please help with DynamicUpdateCommand