13 Replies Latest reply: Mar 6, 2014 3:13 AM by Johan Mostert RSS

    QlikView SQL string length limit

    Jarno Loubser

      I use a loop to build up a SQL string to be sent to SQL server via OLE DB. The loops works fine - when I "capture" the SQL before it gets sent to the database and then paste it into Query Analyzer - it runs and returns results.

       

      If I limit the loop to generate a SQL string of less then 165,000 (approximate) characters it runs throught in QlikView, but over that the script fails withou error.

       

      The question then is - is there a limit to the length of an SQL string the QlikView can handle.