Newbie TableView question

[d_stranz]

This looks reasonable, based on what I have to guess about your DB structure. Without some context around where this code lives, it's hard to say more.

Is it doing what you want?

Please use CODE tags when posting source code for better readability. See my signature block for how to do that.

[Colorado_Al]

Thanks for the reminder on the code tags. My question is how would I change the order of the column display...
IE let's say the database order is ID Name City and I want to display Name City ID So what wuld be the way to assign certain data fields to certain columns.

Thanks.

[d_stranz]

My question is how would I change the order of the column display...

Probably the simplest way would be to use a proxy model, derived from QAbstractProxyModel or one of its derived classes. The methods you would need to override are mapFromSource() / mapToSource() where you swap the columns appropriately. If you want to exclude rows / columns that are in the SQL model, then you should use QSortFilterProxyModel as the base class for your derived model, and implement the filterAcceptsRow() / filterAcceptsColumn() methods.