Hey Dan,
Thanks, I will check out the classes you suggest. I have also had some
success with QSqlQueryModel instead of QSqlTableModel, by setting the
query in such a way as to return the values in the order I want them.
Cheers,
Tom
Dan Kripac wrote:
Hey Tom (hey - don't I work with you? ;-),
Have you tried looking at making a QAbstractProxyModel
<http://www.riverbankcomputing.co.uk/static/Docs/PyQt4/html/qabstractproxymodel.html> subclass
or even better a QSortFilterProxyModel
<http://www.riverbankcomputing.co.uk/static/Docs/PyQt4/html/qsortfilterproxymodel.html> class and
putting it between your QSqlTableModel and your QTableView?
You can override the MapFromSource and MapToSource methods and perhaps
do your column swapping in there? Or maybe you could do it all in the
sort filter model?
Cheers
Dan
On 2 September 2010 17:08, Tom Proctor <[email protected]
<mailto:[email protected]>> wrote:
I would like to use a subclassed QSqlTableModel to fill a
QTableView, but I'd like the order of the columns in the table to
be different from the order of my fields in the database.
I thought there must be some way to modify the query in .select()
but I haven't gotten that to work. Using setQuery only seems to
prevent queries from returning values.
I also tried simply changing horizontalHeader().moveSection() on
the table, but this is ugly as it needs to be reset each time I
filter or select again.
Any ideas?
Thank you,
Tom
_______________________________________________
PyQt mailing list [email protected]
<mailto:[email protected]>
http://www.riverbankcomputing.com/mailman/listinfo/pyqt
_______________________________________________
PyQt mailing list [email protected]
http://www.riverbankcomputing.com/mailman/listinfo/pyqt
