Issue in strings of SQL statements in designer.js
Posted: Mon Sep 26, 2016 9:32 am
Hi,
The new version 2016.2 looks good.
But I have an issue in designer.js
When I enter an sql statement in the designer.js and test within the component all is fine.
But when I preview the report I get errors like:
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\nfrom mcis_rel_uprof_blok rub \r\njoin mcis_blokken bl on\r\n (rub.id_blok =' at line 1
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\nfrom mcis_vakken vk\r\njoin mcis_rel_blok_vak rel ON\r\n(vk.id_vak = rel.id_' at line 1
It seems that there are next line en return string added to the text of the SQL statement. I mean the '\r\n' strings.
The problem occurs at all my existing reports (which do work fine in designer.fx)
Is there a solution for this?
Thank you, André
The new version 2016.2 looks good.
But I have an issue in designer.js
When I enter an sql statement in the designer.js and test within the component all is fine.
But when I preview the report I get errors like:
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\nfrom mcis_rel_uprof_blok rub \r\njoin mcis_blokken bl on\r\n (rub.id_blok =' at line 1
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\nfrom mcis_vakken vk\r\njoin mcis_rel_blok_vak rel ON\r\n(vk.id_vak = rel.id_' at line 1
It seems that there are next line en return string added to the text of the SQL statement. I mean the '\r\n' strings.
The problem occurs at all my existing reports (which do work fine in designer.fx)
Is there a solution for this?
Thank you, André