QTableView sorting with a QSqlTableModel edit strategy set to OnManualSubmit

Hi all,

I developing in qt 4.6.
I am using a QTableView with a QSqlTableModel and my interface allows the users to edit the data (add, modify and delete rows). The edit strategy is set to OnManualSubmit.
Up to now, the users could not sort their data as sorting launch a select behind the scenes and any unsaved changes would be lost.

Does anyone has an idea how to handle such case?

Thanks in advance for any help.