topic Bizarre behaviour setting variables - different in debug mode in QlikView https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169246#M40115 <HTML><HEAD></HEAD><BODY><P>You can also try "sleep":<BR />ActiveDocument.GetApplication.Sleep 1000 ' 1 second</P></BODY></HTML> Fri, 18 Mar 2011 16:57:43 GMT Anonymous 2011-03-18T16:57:43Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169243#M40112 <HTML><HEAD></HEAD><BODY><P></P><P>I'm having a problem with different behaviour in debug mode, compared to test mode in a VBScript module.</P><P>When the user logs in, I have a couple of triggers that check the username, and then decide on the basis of some settings in a 'security' table whether or not a particular sheet should be visible.</P><P>There are variables for each sheet v(sheetname)Visible v(sheetname)Sample that get set and the sheets are set up to show conditionally based on the values in the variables.</P><P>When the code runs on start up, it is not correctly setting one of the variables. If I go into the module editor and run the checkVisibleSheet macro in test mode, it also sets the variable incorrectly. However, if I set a break point and step through the variable setting routine manually in debug mode, it works correctly!</P><BR /><BR /> <P>Any clues - I'm tearing my hair out!!!</P></BODY></HTML> Fri, 18 Mar 2011 14:35:52 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169243#M40112 2011-03-18T14:35:52Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169244#M40113 <HTML><HEAD></HEAD><BODY><P>Maybe it's timeing issue... Try to insert this line before/after setting the variable:<BR />ActiveDocument.GetApplication.WaitForIdle</P></BODY></HTML> Fri, 18 Mar 2011 16:03:20 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169244#M40113 Anonymous 2011-03-18T16:03:20Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169245#M40114 <HTML><HEAD></HEAD><BODY><P>Thanks for the suggestion - it does look like something like that. However, sprinkling those around doesn't seem to make a difference, but I will persevere!</P><P></P></BODY></HTML> Fri, 18 Mar 2011 16:51:25 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169245#M40114 2011-03-18T16:51:25Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169246#M40115 <HTML><HEAD></HEAD><BODY><P>You can also try "sleep":<BR />ActiveDocument.GetApplication.Sleep 1000 ' 1 second</P></BODY></HTML> Fri, 18 Mar 2011 16:57:43 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169246#M40115 Anonymous 2011-03-18T16:57:43Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169247#M40116 <HTML><HEAD></HEAD><BODY><P>Thanks - I have tried some minor recoding and the initial problem seems to have gone away, so I'm keeping everything crossed....</P><P></P></BODY></HTML> Fri, 18 Mar 2011 18:17:53 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169247#M40116 2011-03-18T18:17:53Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169248#M40117 <HTML><HEAD></HEAD><BODY><P>Also, keep in mind that certain QlikView APIs are not available when the macro is running "OnOpen"...</P></BODY></HTML> Fri, 18 Mar 2011 19:55:17 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169248#M40117 Oleg_Troyansky 2011-03-18T19:55:17Z Bizarre behaviour setting variables - different in debug mode https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169249#M40118 <HTML><HEAD></HEAD><BODY><P>Just a note that the .waitforidle script items caused a lot of probems with the Ajax version, although this was not obvious running from the client.</P></BODY></HTML> Mon, 21 Mar 2011 14:10:56 GMT https://community.qlik.com/t5/QlikView/Bizarre-behaviour-setting-variables-different-in-debug-mode/m-p/169249#M40118 2011-03-21T14:10:56Z