title: SQLITE update query fails
body: <p>I am trying to update the table column by appending with new data of QtSQl database. I need to update the column <code>imgpath</code> by appending with new data.</p>
  
  <p>Below is the code, but it always fails, what could be the issue?.</p>
  
  <pre><code>QSqlQuery query(db);
  query.exec("create table table1 (id integer primary key autoincrement, time varchar(20), imgpath varchar(20))");
  
  query.exec("insert into table1 values(NULL,'00:15:25','img0.jpg')");
  query.exec("insert into table1 values(NULL,'00:15:25','img1.jpg')");
  
  bool up = query.exec("update table1 set imgpath=concat(';newImage.jpg',imgpath) where ID=1");
  if(up==false)
     qDebug()&lt;&lt;"Update failed";
  </code></pre>
  
  <p><strong>Update:</strong></p>
  
  <p><em>Complete code:</em></p>
  
  <pre><code>     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
       db.setDatabaseName("./newDB");
       db.open();
  
       QSqlQuery query(db);
       query.exec("create table table1 (id integer primary key autoincrement, time varchar(20), imgpath varchar(20))");
  
       query.exec("insert into table1 values(NULL,'00:15:25','img0.jpg')");
       query.exec("insert into table1 values(NULL,'00:15:25','img1.jpg')");
  
  
  
  
       //bool up = query.exec("update table1 set imgpath='newimage.jpg',time='' where ID=1");
       bool up = query.exec("update table1 set imgpath=concat(';newImage.jpg',imgpath)");
       if(up==false){
           qDebug()&lt;&lt;"Update failed";
           qDebug() &lt;&lt; db.lastError();
       }
  
      query.exec("SELECT * FROM table1 limit 100");
  
       QVector&lt;QStringList&gt; lst;
       while (query.next())
       {
           QSqlRecord record = query.record();
           QStringList tmp;
           for(int i=0; i &lt; record.count(); i++)
           {
               tmp &lt;&lt; record.value(i).toString();
           }
           lst.append(tmp);
       }
       foreach (const QStringList &amp;var, lst) {
           qDebug() &lt;&lt; var;
       }
  </code></pre>