QSqlDatabase and QTableView do not sync( SQLite)

I am using an SQLite database with QSqlDatabase and show data using 2 QTableView with QSqlTableModels.

My application inserts data into tables using QSqlQuery but the tables do not update to display new data (the no of rows displayed to not changed for example). I was expecting new data to be automatically reflected in the QTableView.

What am I doing wrong here?

Paul