topic Script_line_error in a statement - cannot spot it - plz help in QlikView

Script_line_error in a statement - cannot spot it - plz help

datanibbler — Wed, 30 Mar 2016 13:05:28 GMT

Hi,

I have a txt file (qvs) that is INCLUDEd in all my QlikView_apps and contains the hard-coded paths to a lot of qvd_files on the server.

I will attach it. Here are just a few lines from it:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><

SET v_Pfad_Packtimes_qvd = '\\servername\production\01_QVD\QVD\ITEM_PACKTIMES_A164.qvd';

SET v_Pfad_Packtimes_74_qvd = '\\servername\production\01_QVD\QVD\ITEM_PACKTIMES_74.qvd';

SET v_Pfad_Packtimes_08_qvd = '\\servername\production\01_QVD\QVD\ITEM_PACKTIMES_08.qvd';

SET v_Pfad_Historie_Packtimes_qvd = '\\servername\production\01_QVD\QVD\Historie_Item_Packtimes.qvd';

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

The last line that I just added causes an error_message - "Script line error" - I cannot spot any difference, though:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<

SET v_Pfad_SLDtl_A164 _qvd = '\\servername\production\01_QVD\QVD\V_SERIAL_LOT_DETAIL_A164.qvd';

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Can any of you spot anything different from the ones before or anything that I must not do (any faulty characters or such)?

Thanks a lot!

Best regards,

DataNibbler

Re: Script_line_error in a statement - cannot spot it - plz help

swuehl — Wed, 30 Mar 2016 13:15:37 GMT

There seems to be a character between A164 and the underline, notepad++ shows it, also you will see the the cursor needs two steps to proceed.

I believe this character breaks your code.

Re: Script_line_error in a statement - cannot spot it - plz help

marcus_sommer — Wed, 30 Mar 2016 13:16:17 GMT

Hi DataNibbler,

not really unless the marked US chars within the red circle - whereby I don't know why:

- Marcus

Re: Script_line_error in a statement - cannot spot it - plz help

datanibbler — Wed, 30 Mar 2016 13:19:33 GMT

Hi Marcus and Stefan,

you're right - I don't know what that was, but it's not there now and the error_message still persists ...

Re: Script_line_error in a statement - cannot spot it - plz help

swuehl — Wed, 30 Mar 2016 13:21:21 GMT

Might be an indicator for a unit separator. Guess QV does not expect a control char here..

Re: Script_line_error in a statement - cannot spot it - plz help

datanibbler — Wed, 30 Mar 2016 13:24:41 GMT

It's probably something that QlikView interprets as a control_character - but I don't see it, so how can I remove it?

Re: Script_line_error in a statement - cannot spot it - plz help

swuehl — Wed, 30 Mar 2016 13:27:09 GMT

As I said, open an editor and move the cursor to the position. You will see that there is an invisible character you can delete by moving the cursor left and right.

Re: Script_line_error in a statement - cannot spot it - plz help

mohamed_ahid — Wed, 30 Mar 2016 13:42:19 GMT

i have deleted the space before the last line and recreated it .

also rewrite the variable name and it works for me .

try sample bellow.

Re: Script_line_error in a statement - cannot spot it - plz help

datanibbler — Wed, 30 Mar 2016 14:05:46 GMT

All right,

finally I have seen it - between two visible characters (with no visible whatchamacallit inbetween), the cursor took two steps - so there must have been something which QlikView misinterpreted ... I deleted whatever was there and now it works fine 😉

Strange things happen ...