Here's the code i've written so far:
Qt Code:
  1. QTableView *view;
  2.  
  3. model = new QSqlQueryModel;
  4. view = new QTableView;
  5.  
  6. model->setQuery("SELECT s.scan_date,p.surname,p.first_name,p.nric_no,p.dob,p.gender,r.description FROM PATIENT p,RACE r, SCAN_DATA s WHERE p.race = r.race AND p.patient_id=s.patient_id AND p.surname = '" + patientNamestr + "'");
  7. model->setHeaderData(0, Qt::Horizontal, QObject::tr("Scan Date"));
  8. model->setHeaderData(1, Qt::Horizontal, QObject::tr("Surname"));
  9. model->setHeaderData(2, Qt::Horizontal, QObject::tr("First name"));
  10. model->setHeaderData(3, Qt::Horizontal, QObject::tr("NRIC"));
  11. model->setHeaderData(4, Qt::Horizontal, QObject::tr("DOB"));
  12. model->setHeaderData(5, Qt::Horizontal, QObject::tr("Gender"));
  13. model->setHeaderData(6, Qt::Horizontal, QObject::tr("Race"));
  14.  
  15. view->setModel(model);
  16. view->setSelectionBehavior(QAbstractItemView::SelectRows);
  17. view->setSelectionMode(QAbstractItemView::SingleSelection);
  18.  
  19.  
  20. view->show();
To copy to clipboard, switch view to plain text mode 

When a row is selected in the table view, i want to connect it to a slot.
How to do that? Thanks.