dynamic field, extendible with VB script

[#1]

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

[Oleg_Troyansky]

If you are using version 9, look in the APIGuide for the new API "DynamicUpdateCommand" and follow the example.

[#3]

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

[#4]

I forget to set EnableDynamicDataUpdate=true in the document properties.

It works now...

Thanks Oleg!!