Semantic error after upgrade QlikView to 12.20

[janturon]

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

[janturon · Accepted solution]

I found

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

there is one more sign " after qvd

[Peter_Cammaert]

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