topic Re: 'Unexpected token' error - Upgrade from QV 11 to QV12 in QlikView

'Unexpected token' error - Upgrade from QV 11 to QV12

Hollis — Sat, 16 Nov 2024 21:14:15 GMT

Hi Guys,

I used the subroutine to stored files in csv-format, the related scripts is as below:

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (ansi, txt, delimiter is ';');

It works well in QV11, but when run in QV12, it shows the error message.

Error: Unexpected token: 'ansi', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'.

Anyone can help?

Thank you very much.

joseph_morales — Fri, 15 Mar 2019 04:57:39 GMT

You must delete the ANSI

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (txt, delimiter is ';');

Regards

Hollis — Fri, 15 Mar 2019 05:40:17 GMT

Hi Joseph_Morales,
May I know the reason for this? Since it works well in QV11.

rwunderlich — Fri, 15 Mar 2019 07:46:11 GMT

QV12 is more strict on syntax. "ansi" never was a valid keyword for STORE, but QV11 tolerated (and ignored it). QV12 does not.

-Rob

Hollis — Fri, 15 Mar 2019 08:19:38 GMT

Thanks a lot.