topic Re: Qlikview script line error in QlikView

Qlikview script line error

Mon, 28 Dec 2015 09:10:12 GMT

hi All,

i am coding in Qlikview 11 and i have written and i received a "Script line error" just after a CALL like this

CALL my_proc('param_1','param_2')

i have no idea why, someone have some suggestion?

thanks a lot.

Re: Qlikview script line error

Peter_Cammaert — Mon, 28 Dec 2015 09:31:31 GMT

Is subroutine my_proc defined before the CALL statement? QlikView does not perform a lookahead, or a preparsing step. The subroutine should already exist before you can make use of it.

Re: Qlikview script line error

Anonymous — Mon, 28 Dec 2015 09:38:19 GMT

check this:

How to Call stored procedure in Qlikview

Executing Stored procedure in QlikView | Learn QlikView

Re: Qlikview script line error

Mon, 28 Dec 2015 09:43:28 GMT

yes, i have declare before calling, the strange things is that i have different part in my script that has the same structure and all other part work well; is only this part that as this problem.

Re: Qlikview script line error

Peter_Cammaert — Mon, 28 Dec 2015 10:08:03 GMT

Check the number of parameters. Does my_proc really expect two parameters?

Re: Qlikview script line error

Kushal_Chawda — Mon, 28 Dec 2015 10:12:13 GMT

what is the definition of subroutine? what actually subroutine does?

Re: Qlikview script line error

Mon, 28 Dec 2015 10:34:00 GMT

this is the call

CALL My_Proc('$(v_variable)','out_one.qvd','out_two.qvd','done','[Field_one],[Field_two]')

this is the declaration

sub My_Proc(p_source,p_out_oneN,p_out_twoN,p_typeN,p_fields)

as type of calling is the same of other (i mean that i have other routine that work the same as this with the same parameters) but this is the only that give me problem the others give me correct output.

Re: Qlikview script line error

Peter_Cammaert — Mon, 28 Dec 2015 11:25:44 GMT

So what's in v_variable at the time of the CALL? I hope it doesn't contain any strings with quotes.

Re: Qlikview script line error

Peter_Cammaert — Mon, 28 Dec 2015 11:28:00 GMT

If you want to be sure what exacly the CALL statement-with-parameters looks like at the time of execution, generate a document log and search for the Script line error message in that log. The $-sign expanded CALL statement will precede the error message.

Re: Qlikview script line error

Mon, 28 Dec 2015 11:28:47 GMT

v_variable contain a source:

is like this:

..\Datasource\sourcefile.qvd

it doesn't have quotes inside.

Re: Qlikview script line error

Mon, 28 Dec 2015 11:30:30 GMT

i have document log but i don't understand why happen this error, i tryed also to follow everithing with debug mode and check all the variable.

Re: Qlikview script line error

Tue, 29 Dec 2015 13:33:03 GMT

i found the problem.

i wrote two subroutine with the same name and only if i tried to call it gave me an error.

i hope that my experience can help other with stupid error like mine.

thanks to everyone.

Re: Qlikview script line error

Peter_Cammaert — Tue, 29 Dec 2015 14:30:14 GMT

Noted.

BTW did the last definition still correspond the CALL interface (number of parameters the same). I would assume that the second definition overwrites the first one...

Re: Qlikview script line error

Tue, 29 Dec 2015 14:33:10 GMT

Yes, the second definition doesn't have parameters and is for that the error.

Re: Qlikview script line error

Peter_Cammaert — Tue, 29 Dec 2015 14:34:35 GMT

I'll answer my own question: Probably not.

The following code executes perfectly:

SUB my_proc(vParm1)

SET vFlag = ProcDef1;

END SUB

SUB my_proc(vParm1001)

SET vFlag = ProcDef2;

END SUB

CALL My_Proc('val1');

And variable vFlag will contain 'ProcDef2', meaning that the last definition is being executed. It's not just the fact that you defined your SUB twice that causes this error.

Re: Qlikview script line error

Tue, 29 Dec 2015 14:39:52 GMT

thank you for explanation