PDA

View Full Version : How to InsertRow Throught QSqlQueryModel ?



innobleday
24th March 2010, 04:44
Hi All,
I have a little problem with my QtCode, perhaps u guys can help me to solve the problem and I'll very appreciate. In my code, I aim to put an empty code to the QTableView whereas the query is get from QSqlQueryModel. I tried with sqlQueryModel->insertRow(0);, but nothing happend in the table. Completely the code looks like this


sqlQueryModel->setQuery("SELECT * FROM x=a, y=b where b.ID = 0AND (b.anotherid = a.anotherid )",sqlDatabase);
sqlQueryModel->setHeaderData(0,Qt::Horizontal,tr("1"));
sqlQueryModel->setHeaderData(1,Qt::Horizontal,tr("2"));
sqlQueryModel->setHeaderData(2,Qt::Horizontal,tr("3"));

ui->tableView->setModel(sqlQueryModel );
ui->tableView->setSelectionMode(QAbstractItemView::SingleSelectio n);
ui->tableView->setSelectionBehavior(QAbstractItemView::SelectRows );
ui->tableView->resizeColumnsToContents(); // resize column width depend to data cell
ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers) ; //unable edit through the cell
ui->tableView->verticalHeader()->setHidden(true);
ui->tableView->selectRow(0);

header = ui->tableView->horizontalHeader();
header->setResizeMode(QHeaderView::Stretch);

sqlQueryModel->insertRow(0);


I hope it can describe what the problem is.
Thanks.