QString search
= "SELECT sname, ssurname, sidcard, dtdob, id FROM users WHERE iaccesslevel=:iaccesslevel AND (id=:id0 OR id = :id1)";
QSqlQuery myquery
(*m_pI
->m_pUsersDB
->GetDBPtr
());
myquery.prepare(search);
myquery.bindValue(":iaccesslevel", 1);
myquery.bindValue(":id0", 14); //For instance, id = 14
myquery.bindValue(":id1", 15);
alumnosFiltrados.exec();
m_pI->m_pQueryModel->setQuery(myquery);
m_pI->m_pQueryModel->setHeaderData(0, Qt::Horizontal, tr("Nombre") );
m_pI->m_pQueryModel->setHeaderData(1, Qt::Horizontal, tr("Apellidos") );
m_pI->m_pQueryModel->setHeaderData(2, Qt::Horizontal, tr("NIF") );
m_pI->m_pQueryModel->setHeaderData(3, Qt::Horizontal, tr("Fecha Nacimiento") );
ui.my_tableView->setModel(m_pI->m_pQueryModel);
ui. my_tableView->setColumnHidden(4, true);
QString search = "SELECT sname, ssurname, sidcard, dtdob, id FROM users WHERE iaccesslevel=:iaccesslevel AND (id=:id0 OR id = :id1)";
QSqlQuery myquery(*m_pI->m_pUsersDB->GetDBPtr());
myquery.prepare(search);
myquery.bindValue(":iaccesslevel", 1);
myquery.bindValue(":id0", 14); //For instance, id = 14
myquery.bindValue(":id1", 15);
alumnosFiltrados.exec();
m_pI->m_pQueryModel->setQuery(myquery);
m_pI->m_pQueryModel->setHeaderData(0, Qt::Horizontal, tr("Nombre") );
m_pI->m_pQueryModel->setHeaderData(1, Qt::Horizontal, tr("Apellidos") );
m_pI->m_pQueryModel->setHeaderData(2, Qt::Horizontal, tr("NIF") );
m_pI->m_pQueryModel->setHeaderData(3, Qt::Horizontal, tr("Fecha Nacimiento") );
ui.my_tableView->setModel(m_pI->m_pQueryModel);
ui. my_tableView->setColumnHidden(4, true);
To copy to clipboard, switch view to plain text mode
Bookmarks