<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Bug Qlik Sense 2017 sept? Syntax error in SQL in generated script in Archived Groups</title>
    <link>https://community.qlik.com/t5/Archived-Groups/Bug-Qlik-Sense-2017-sept-Syntax-error-in-SQL-in-generated-script/m-p/1392413#M3712</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;After installing Qlik Sense 2017 September I need to change my scripts.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;It needs double quotes around de database name and te owner.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;BR /&gt;If I generate the script, Qlik suggests a script like:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;EM&gt;Test:&lt;/EM&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;LOAD cdadmin;&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;SQL SELECT cdadmin&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;FROM DATA.PUB."aa-100";&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;Exit script;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt; This gives the following error:&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="selectable" style="margin: 0 0 0 5px;"&gt;---&lt;/P&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt;&lt;SPAN style="color: #ff0000;"&gt;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)&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt;---&lt;/DIV&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt; &lt;/DIV&gt;&lt;P&gt;I works correct if I manualy change the script to &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;EM&gt;Test:&lt;/EM&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;LOAD cdadmin;&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;SQL SELECT cdadmin&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;FROM &lt;STRONG&gt;"DATA"&lt;/STRONG&gt;.&lt;STRONG&gt;"PUB"&lt;/STRONG&gt;."aa-100";&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;(I am connecting to a Progress OpenEdge database)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 23 Jul 2025 14:48:52 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2025-07-23T14:48:52Z</dc:date>
    <item>
      <title>Bug Qlik Sense 2017 sept? Syntax error in SQL in generated script</title>
      <link>https://community.qlik.com/t5/Archived-Groups/Bug-Qlik-Sense-2017-sept-Syntax-error-in-SQL-in-generated-script/m-p/1392413#M3712</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;After installing Qlik Sense 2017 September I need to change my scripts.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;It needs double quotes around de database name and te owner.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;BR /&gt;If I generate the script, Qlik suggests a script like:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;EM&gt;Test:&lt;/EM&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;LOAD cdadmin;&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;SQL SELECT cdadmin&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;FROM DATA.PUB."aa-100";&lt;/EM&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;EM&gt;Exit script;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt; This gives the following error:&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="selectable" style="margin: 0 0 0 5px;"&gt;---&lt;/P&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt;&lt;SPAN style="color: #ff0000;"&gt;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)&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt;---&lt;/DIV&gt;&lt;DIV class="selectable" style="margin: 0 0 0 5px;"&gt; &lt;/DIV&gt;&lt;P&gt;I works correct if I manualy change the script to &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;SPAN style="color: #000000; font-size: 13px; font-family: arial, helvetica, sans-serif;"&gt;&lt;EM&gt;Test:&lt;/EM&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;LOAD cdadmin;&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;SQL SELECT cdadmin&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px; padding-left: 30px;"&gt;&lt;EM&gt;FROM &lt;STRONG&gt;"DATA"&lt;/STRONG&gt;.&lt;STRONG&gt;"PUB"&lt;/STRONG&gt;."aa-100";&lt;/EM&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;(I am connecting to a Progress OpenEdge database)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 23 Jul 2025 14:48:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Archived-Groups/Bug-Qlik-Sense-2017-sept-Syntax-error-in-SQL-in-generated-script/m-p/1392413#M3712</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2025-07-23T14:48:52Z</dc:date>
    </item>
  </channel>
</rss>

