15 Replies Latest reply: Mar 27, 2012 12:08 PM by Ravi Kumar RSS

    Edit Script Function

    Charles Bauer

      Using QV 8.5 latest build. Had no problems till today. Every time I hit the Edit Script button the program freezes and I have to use CTRL-ALT-DEL to end program.

      QV will reload, run macros and all files and sheets are working just I can't edit script. The system does not show not responding or an error at all.

      Thanks for any help provided.

        • Edit Script Function
          Michael Solomovich

          Does it happen with a specific qvw file or with any file? I'd recommend to uninstall and reinstall QlikView.

          • Edit Script Function
            Rob Wunderlich

            I have had this happen before with a single QVW. (If it's happening with all your qvws, I'd go with Michael's suggestion of reinstalling).

            If it's just one file, you'll have to rebuild the file using a backup. Or you can try to extract the script with this macro:

            Sub extractScript
            Set objTextFile = openOutputFile("C:\myscript.qvs")
            objTextFile.WriteLine(ActiveDocument.GetProperties.Script)
            objTextFile.Close()
            End Sub

            Function openOutputFile(filename)
            Rem *** Create and open an output file
            CONST ForWriting = 2
            Set objFSO = CreateObject("Scripting.FileSystemObject")
            Set openOutputFile = objFSO.OpenTextFile (filename, ForWriting, True)
            End Function

            Code it in your module and run it with Test. You'll have to grant System Access. That will extract your script to a file. Then run another macro like:

            Sub fix
            set docprop = ActiveDocument.GetProperties
            docprop.Script = "empty"
            ActiveDocument.SetProperties docprop
            End Sub

            Then if you can edit the script, you can copy/paste from the file -- after looking it over for weirdness.

            -Rob

              • Re: Edit Script Function
                Ravi Kumar

                Hi Rob,

                 

                I tried below macro code for adding new script line into existed tab "Main 2" ,

                 

                but the below code working like creating another new tab "Main 2" and adding the script line as $(Include=d:\vqd eat\text\test.txt);

                 

                what to change in below code for to work like add new script line in existed tab "Main 2" ?

                 

                 

                docprop.Script = docprop.Script & chr(13) & chr(10) & "///$tab Main 2" & chr(13) & chr(10) & "$(Include=d:\vqd eat\text\test.txt);"

                 

                 

                 

                Thanks in advance

              • Edit Script Function
                Johannes Sunden

                If it's a specific document I've seen this happen where global variables have been defined in the Macro module. Try commenting out everything in the macro module which is not enclosed within Subs or Functions and see if that lets you access the script.

                  • Edit Script Function
                    Charles Bauer

                    Unfortunly its EVERY document including starting a new file and the samples.

                    • Edit Script Function
                      Johannes Sunden

                      Hmm..

                      I'm thinking that the coordinates for the script window might have become messed up somehow so that the window is actually opening outside the visible computer screen and taking focus from QV so that it appears to have hung.

                      After clicking Edit Script, hold down Alt, push Space once and hit M (as in move). Then let go of all keys and use the arrow keys to try and move the script window into the screen area. Hope this works.

                        • Edit Script Function
                          Michael Solomovich

                          jsn,
                          This is exactly what I was thinking about. And, occasionally it happens to the "edit macro" window as well. I think that QlikTech has a utility to restore the position of the edit script window, hasn't it?

                          • Edit Script Function
                            Charles Bauer

                            It worked. Thanks jsn and to all who suggested answers and help it was greatly appreciated.

                              • Edit Script Function
                                ivang

                                I have had this happen if I use QlikView with a second monitor and extend the desktop to that monitor. If I move the editor screen to the second monitor, then later open QlikView without the second monitor the Editor still opens where it was with the second monitor. I do notice that I can see the edge of the editor window at the edge of my screen, and my mouse pointer turns into an arrow so I can drag the editor edge into view.

                                I wonder, can we class this as a bug?

                                I had forgotten the Alt-M trick though - good call.

                                  • Edit Script Function
                                    Johannes Sunden

                                    Michael,

                                    Not sure on the app to reset the window pos. I did however track down the registry value for this so that one can check it manually:

                                    Computer\HKEY_CURRENT_USER\Software\QlikTech\QlikView\WindowPos

                                    DlgPos334 - Script Editor

                                    For example:

                                    193,132,960,641,0

                                    TopLeftX, TopLeftY, BottomRightX, BottomRightY, Maximized (1/0)

                                      • Edit Script Function
                                        Michael Solomovich

                                        jsn,
                                        It's good enough, thanks! Especaily that the DlgPos334 is for the script editor.
                                        Can we get the macro editor? Variables overview?

                                          • Edit Script Function
                                            Johannes Sunden

                                            Yeah.. I looked it up manually. Took a screenshot of the registry and then moved the script editor and compared. The principle is the same for the others but I'm on macos at the moment so I can't help you out there.

                                            • Edit Script Function
                                              Rob Wunderlich

                                               


                                              Michael Solomovich wrote:Especaily that the DlgPos334 is for the script editor.
                                              Can we get the macro editor?


                                              If you're up for it, an easy way to determine the various registry keys is to use a monitoring tool like Procmon or Regmon from Sysinternals -- free tools now distributed by Microsoft at http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx

                                              Technically, Regmon is for older versions of Windows but it works fine on my XP. Regmon has filters so you can monitor just want you want like "HKCU\SOFTWARE\QlikTech\QlikView\WindowPos\*". Procmon has filters also, a little more complex to setup because it monitors more than RegKeys.

                                              Using Regmon, I can see that the WindowPos keys are:

                                              DlgPos334 - Script Editor V9
                                              DlgPos332 - Script Editor V8.5
                                              DlgPos257 - Macro Editor V9
                                              DlgPos254 - Macro Edito V8.5

                                              Thought it was interesting that they differ between releases.

                                              -Rob

                                  • Edit Script Function
                                    Michael Solomovich

                                    Here, I knew I had it... It is QlikTech's file. No any documenmtaion or description though.