Hi! I need your help. I'm a beginner. I'd like to call SQL Procedure (MySQL) [ in the body of procedure there is for example: SELECT * FROM table; ]. I'd like to see result in QTableView. How should I do that?
It works:
void MainWindow::something()
{
queryModel = new QSqlQueryModel(table);
queryModel->setQuery("SELECT * FROM table", db);
if (queryModel -> lastError().type() != QSqlError::NoError)
DBError (queryModel -> lastError());
else
table -> setModel(queryModel);
table->show();
}
It doesn't work:
void MainWindow::something()
{
queryModel = new QSqlQueryModel(table);
queryModel->setQuery("CALL MyProcedure()", db);
if (queryModel -> lastError().type() != QSqlError::NoError)
DBError (queryModel -> lastError());
else
table -> setModel(queryModel);
table->show();
}
Please help me. It's very important for me.
Thanks
Piotr
P.S. I'm sorry for my English language.
