Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
janturon
Contributor III
Contributor III

Semantic error after upgrade QlikView to 12.20

Hi,

I have upgrade my QlikView to version 12.20 and after that my script (see below) falls on row "For i = 0 to vRows -1" by Srcipt Error -> "

Semantic error For i = 0 to vRows - 1"

I have used this script for 3 years and without any problem.

SET i = ;

SET vFile = ;

SET vRows = ;

FOR Each vFile in FileList('dbf_pm20*.qvd"')

    TRACE $(vFile);

    Subory:

    LOAD

        '$(vFile)' as Subor

    AutoGenerate 1;

NEXT vFile

LET vRows = NoOfRows('Subory');

POHYBY:

LOAD  * INLINE

    [REG]

;

For i = 0 to vRows - 1

    LET vFile = Peek('Subor', i, 'Subory');

    TRACE $(vFile);

   

    Concatenate (POHYBY)

    LOAD DATE(DATE#(DATUM,'DD/MM/YYYY'),'DD-MM-YYYY') as FDATUM,

    *

    FROM

    [$(vFile)] (qvd);

STORE POHYBY into D:\DW\poh.QVD;   

Next i

1 Solution

Accepted Solutions
janturon
Contributor III
Contributor III
Author

I found

FOR Each vFile in FileList('dbf_pm20*.qvd"')

there is one more sign " after qvd

View solution in original post

2 Replies
janturon
Contributor III
Contributor III
Author

I found

FOR Each vFile in FileList('dbf_pm20*.qvd"')

there is one more sign " after qvd

Peter_Cammaert
Partner - Champion III
Partner - Champion III

FYI: QlikView v12.20 has become much stricter when dealing with script "errors" (or script constructs that do not adhere to the BNF syntax specification) that used to work in older versions. This is a really good thing.

However if you feel that it causes too much trouble in your current environment, you can still revert to the old - more forgiving - behavior. You can disable this strict mode either for the entire server or for specific applications only.

See "BNF Script Reload Mode" in the Release Notes for QlikView November 2017 - Patch 122020100, also available here: QlikView November 2017 IR - Relase Notes