There is a good technique to solve that problem:

1. Obtain sqliteman (www.sqliteman.com) and verify your queries manually.
2. Code like that:


Qt Code: 
  1. QString sql = QString("ALTER TABLE '%1' ADD COLUMN '%2' %3;")
  2.                 .arg(s_db_alter_table_list[i].table)
  3.                 .arg(s_db_alter_table_list[i].column)
  4.                 .arg(s_db_alter_table_list[i].settings);
  5.  
  6.             QSqlQuery query(m_db);
  7.             query.exec(sql);
  8.  
  9.             if (query.lastError().isValid())
  10.             {
  11.                 if (m_useLogging)
  12.                     emit log(BRIDGE_COMPONENT_ID, priHigh, QString("Alter table %1 error %2 during SQL statement: %3")
  13.                         .arg(s_db_alter_table_list[i].table).arg(query.lastError().text()).arg(query.lastQuery()));
  14.  
  15.                 emit error(QString("Alter table error %1 during SQL statement: %2")
  16.                     .arg(query.lastError().text())
  17.                     .arg(query.lastQuery()));
  18.                 return false;
  19.             }
To copy to clipboard, switch view to plain text mode