Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
does anybody know if there is a possibility to have kind of a dynamic field, where I can add and remove elements with VB script at runtime. The user should see the field with an sheet object.
Somehow I need to show existing sheet objects and tables which I created by VB script to the user and where he could select one...
Any advice for the realization would be helpful...
If you are using version 9, look in the APIGuide for the new API "DynamicUpdateCommand" and follow the example.
Thanks, trying it i had a problem
I did the following:
in the load script:
Test:
LOAD * INLINE [
TestTest
Sheet1
];
when I execute the statement:
set result = ActiveDocument.DynamicUpdateCommand("INSERT INTO * (TestTest) VALUES (asd)")
qlikview marks the line such as it is an Error but doesn't give me an error message. Do you know what wrong is??
I forget to set EnableDynamicDataUpdate=true in the document properties.
It works now...
Thanks Oleg!!