topic Error in a macro in QlikView

Error in a macro

ecolomer — Mon, 01 Sep 2014 13:49:36 GMT

I have a strange behavior in a Macro that you need to do is update the fields in a table.

This is the macro:

sub OutLote

for k = 1 to ActiveDocument.Evaluate("=getSelectedCount(Order_Id)")

OutValue = ActiveDocument.Evaluate("=subfield(getFieldSelections(Order_Id, ';', 25), ';' ,"&k&")")

ActiveDocument.DynamicUpdateCommand("UPDATE SEL SET Lote=Null() WHERE Order_Id="&OutValue&"")

next

end sub

The strange behavior is that sometimes leaves the computer "hung" and do not know why it is. The same is silly but not see it.

Its aim is to update a table (SEL) with basic data are:

Order_Id, Lot and Date

In this case, you must make is to put the Lot = Null in the records selected through Order-Id.

In some cases, when multiple values are selected Order_Id eg 10 values (limit of 25), running, does it perfectly for 5 different, if we run without doing anything more, is doing well other 2 or 3 and so on down.

At the end is where you leave your computer "hanging"

Can you check it?

Enrique

Re: Error in a macro

phaneendra_kunc — Mon, 01 Sep 2014 14:23:48 GMT

have you tired with "Sleep" command to give it a time to "commit" your update to your table?

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 14:29:10 GMT

I don't know what you explain

Re: Error in a macro

Mon, 01 Sep 2014 14:38:15 GMT

Did you check the Database Logs?-Ram

Re: Error in a macro

phaneendra_kunc — Mon, 01 Sep 2014 14:39:25 GMT

sorry..I meant your app might be hanging because script is not giving enough time to respond..

there is a command to introduce time lag between your operations.. which is "GetApplication.WaitForIdle"

try below..

sub OutLote

for k = 1 to ActiveDocument.Evaluate("=getSelectedCount(Order_Id)")

OutValue = ActiveDocument.Evaluate("=subfield(getFieldSelections(Order_Id, ';', 25), ';' ,"&k&")")

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.DynamicUpdateCommand("UPDATE SEL SET Lote=Null() WHERE Order_Id="&OutValue&"")

ActiveDocument.GetApplication.WaitForIdle

next

end sub

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 14:39:51 GMT

The table is only in memory, at the end export to excel

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 14:46:32 GMT

I have not noticed any changes

System are execute Macro and don't finish

Re: Error in a macro

rajeshvaswani77 — Mon, 01 Sep 2014 14:48:20 GMT

You can put a message box and debug. Also if you go in debug mode line by line and it works, you would need a wait for idle then.

thanks,

Rajesh Vaswani

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 14:54:45 GMT

Attached are QV an excel

Re: Error in a macro

marcus_sommer — Mon, 01 Sep 2014 14:58:51 GMT

In such cases I would log the activities from the macro in a txt-file:

set LogFile = fso.OpenTextFile("D:\XourPath\Log\MacroLog.txt", 8, true)

LogFile.Writeline str

whereat str = k & timestamp & Update-Statement ... & chr(10)

- Marcus

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 17:48:50 GMT

Any idea??

Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 19:17:45 GMT

I can put msgbox, but I don't know activwe debug mode

Re: Re: Error in a macro

ecolomer — Mon, 01 Sep 2014 20:56:28 GMT

New version ... QV

Now works ...!!