I'm connection a DBGridTableView to a SQLITE database. The problem is, that it only displays the first 256 rows of the database table. How can I force the DBGridTableView to fetch more rows when the end of the view is reached (like the QTableView does).
thanks for your answer. From my point of view this is not an option, since using your workaround means that the whole database is loaded into memory, which is impossible with my 50GB database.
How is it solved in the orginal QT tableview? Using this widget, the view automatically fetches more rows when the end of the table is reached by scrolling down (and I guess some records at the top of the table are thrown aways).
Support for fetch mode is not implemented at the moment by the following reason. In our opinion, the interface QSqlTableModel/QAbstractItemModel is not enough for the support of sequential mode for tables with large amounts of data. So QTableView use the RowCount() method after the fetchMore() has invoked. We think it is necessary to have Next, Prev, First, Next functions to support large tables (sequential mode). In this case the grid's scroller should have 3 pos only (First, Last, Current). According to my information QTablleVIew does not support this mode.