Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Script_line_error in a statement - cannot spot it - plz help

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

1 Solution

Accepted Solutions
mohamed_ahid
Partner - Specialist
Partner - Specialist

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.

View solution in original post

8 Replies
swuehl
MVP
MVP

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.

marcus_sommer

Hi DataNibbler,

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

- Marcus

datanibbler
Champion
Champion
Author

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 ...

swuehl
MVP
MVP

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

datanibbler
Champion
Champion
Author

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

swuehl
MVP
MVP

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.

mohamed_ahid
Partner - Specialist
Partner - Specialist

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.

datanibbler
Champion
Champion
Author

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 ...