Hi.<div><br></div><div>1. ) I'm trying to connect to Netezza db via QSqlDatabase. </div><div>The connection is opened and i can get info from db (table names...)</div><div><br></div><div>2.) But when i try to make a query and display it in a QTableView is get the following error:</div>
<div> "Forward-only queries cannot be used in a data model"</div><div><br></div><div>3.) What is the preferred and fastest way of displaying forward only queries?</div><div><br></div><div>4.) Code:</div><div>
<br></div><div><div> model = QtSql.QSqlQueryModel()</div><div> model.setQuery(self.getSql(), db=self.conn2)</div><div><br></div><div> self.table = QtGui.QTableView()</div><div> self.table.setModel(model)</div>
</div><div><br></div><div>Thanks</div><div>Dusan</div>