I tried removing some records from QSqlQuery using query.record().remove(pos) but it doesn't work at all. Is there any way to remove the record from QSqlQuery? I know about QSqlQueryModel, but I would like to use QSqlQuery, because it works fine for my application.

There is the code:
Qt Code:
  1. #include "QtSql/QtSql"
  2. #include "QtSql/QSqlRecord"
  3.  
  4. QString sql_str;
  5. sql_str = "select * from param";
  6. QSqlQuery query;
  7. query.prepare(sql_str);
  8. query.exec();
  9.  
  10. int index=0;
  11.  
  12. query.seek(-1);
  13.  
  14. while(query.next()){
  15. query.record().clear();
  16. query.record().clearValues();
  17. query.record().remove(0);
  18. ui->tableWidget_2->setItem(index,0,new QTableWidgetItem(query.record().value(0).toString()));
  19. ui->tableWidget_2->setItem(index,1,new QTableWidgetItem(query.value(1).toString()));
  20. ui->tableWidget_2->setItem(index,2,new QTableWidgetItem(query.value(2).toString()));
  21. ui->tableWidget_2->setItem(index,3,new QTableWidgetItem(query.value(3).toString()));
  22. index++;
  23. }
To copy to clipboard, switch view to plain text mode 

I use Qt Creator 1.3.0 based on Qt 4.6.0 (32-bit)
Nov 27 2009 at 14:53:38
Revision c0e849ecc3