topic Macros in QlikView

Macros

Wed, 02 Mar 2011 05:19:27 GMT

Hi,

I had written the macros to write back to the database. Once i have deployed it. It is not working. Do i need to change any settings. Please let me know steps. As of now i called the macro through the button action.

Macros

kaushalview — Wed, 02 Mar 2011 08:04:23 GMT

XXX

1.First u check ur macro code right or not.

2.go to the setting ----->Document----->Security---->Check the Macro Override Property .

3. Plz see img

Regrard

Kaushal Mehta

Macros

amars — Wed, 02 Mar 2011 08:10:56 GMT

I am not very sure about this but check User Preferences -> Security -> Script(Allow Database Write and Execute Statements) is checked or not.

thanks

Macros

kaushalview — Wed, 02 Mar 2011 08:27:10 GMT

I attached screenshot img

Regrads

kaushal mehta

Macros

Wed, 02 Mar 2011 08:54:23 GMT

Thanks for all your responses.

I have fixed the issue.

I have used the macro to establish DB connection,Open the database and write the Query it is not necessary to enable the Open databases in Read and Write Mode option.

I have enabled the server settings now. Also i removed the msgbox from the vbscript macro and now it is working.