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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bug Qlik Sense 2017 sept? Syntax error in SQL in generated script

After installing Qlik Sense 2017 September I need to change my scripts.

It needs double quotes around de database name and te owner.


If I generate the script, Qlik suggests a script like:


Test:

LOAD cdadmin;

SQL SELECT cdadmin

FROM DATA.PUB."aa-100";

Exit script;

This gives the following error:

---

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 4294757240, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "; exit script; " (10713)
---

I works correct if I manualy change the script to

Test:

LOAD cdadmin;

SQL SELECT cdadmin

FROM "DATA"."PUB"."aa-100";

(I am connecting to a Progress OpenEdge database)

Labels (3)
0 Replies