Here's the code i've written so far:
Qt Code: 
  2. QTableView *view;
  3.  
  4. model = new QSqlQueryModel;
  5. view = new QTableView;
  6.  
  7. 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 + "'");
  8. model->setHeaderData(0, Qt::Horizontal, QObject::tr("Scan Date"));
  9. model->setHeaderData(1, Qt::Horizontal, QObject::tr("Surname"));
  10. model->setHeaderData(2, Qt::Horizontal, QObject::tr("First name"));
  11. model->setHeaderData(3, Qt::Horizontal, QObject::tr("NRIC"));
  12. model->setHeaderData(4, Qt::Horizontal, QObject::tr("DOB"));
  13. model->setHeaderData(5, Qt::Horizontal, QObject::tr("Gender"));
  14. model->setHeaderData(6, Qt::Horizontal, QObject::tr("Race"));
  15.  
  16. view->setModel(model);
  17. view->setSelectionBehavior(QAbstractItemView::SelectRows);
  18. view->setSelectionMode(QAbstractItemView::SingleSelection);
  19.  
  20.  
  21. 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.