[PyQt] Forward only query
dusan smitran
dusan.smitran at gmail.com
Tue Aug 10 09:40:59 BST 2010
Hi.
1. ) I'm trying to connect to Netezza db via QSqlDatabase.
The connection is opened and i can get info from db (table names...)
2.) But when i try to make a query and display it in a QTableView is get the
following error:
"Forward-only queries cannot be used in a data model"
3.) What is the preferred and fastest way of displaying forward only
queries?
4.) Code:
model = QtSql.QSqlQueryModel()
model.setQuery(self.getSql(), db=self.conn2)
self.table = QtGui.QTableView()
self.table.setModel(model)
Thanks
Dusan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.riverbankcomputing.com/pipermail/pyqt/attachments/20100810/b611bf52/attachment.html>
More information about the PyQt
mailing list