sql - Sqlite query not working in Qtcreator -
the following query works fine in sqlite not in qt creator.the creator hangs on running app. after stopping build gives error message exited code 62097 code snippet below:
qt code:
qstring str = qstring("select a.name, d.title, b.start_time channel join broadcast_schedule b on a.channel_id =b.channel_id join content_instance c on b.instance_id =c.instance_id join content d on d.content_id = c.content_id group a.name, d.title "); query.prepare(str); query.exec(); while( query.next() ) { model->setquery(query); ui->tableview->setmodel(model); ui->tableview->resizecolumnstocontents(); ui->tableview->show(); ui->tableview->verticalheader()->setvisible(false); ui->tableview->horizontalheader()->setvisible(false); }
why query not working in qt
Comments
Post a Comment