PyQT Database etc

[jpn]

Well, an SQL model + view is much better choice for showing data from database...

• QSqlQueryModel
• QSqlTableModel
• QListView

[peterjb31]

Thanks, that makes a lot more sense that what I was trying to do. I am however still struggling to work out how to implement this. I read some documentation on QListView and the QSqlQueryModel here.

I don't understand how I create the model and then reference it. If anyone could either point me to an example of the code used (can't seem to find any for pyqt when I google) or alternatively post an example I would be extremely greatful.

[peterjb31]

I have created a QSqlModel using the following code in Python:

self.model = QSqlQueryModel
		self.model.setQuery("SELECT companyName FROM suppliers");

self.model = QSqlQueryModel
		self.model.setQuery("SELECT companyName FROM suppliers");

To copy to clipboard, switch view to plain text mode 

However when I try to run the code I get the following error:

TypeError: first argument of unbound method QSqlQueryModel.setQuery() must be a QSqlQueryModel instance

Would anyone be able to advise as to what the error is. Have I declared the QueryModel properly, if not how do I?

[jpn]

Excuse me, I'm not a Python expert but shouldn't it be:

self.model = QSqlQueryModel()

self.model = QSqlQueryModel()

To copy to clipboard, switch view to plain text mode 

?