Details
-
Suggestion
-
Resolution: Fixed
-
P3: Somewhat important
-
5.15.17, 6.7.1
-
730de6fbb (dev), 03e6f3859 (6.8), 8733d292f (6.7)
Description
IRIS, a popular QDBC 3.5 compatible database requires SQL_ATTR_CURSOR_SCROLLABLE=1 to work correctly. Without that option, QSqlTableModel complains about "Forward-only queries cannot be used in a data model".
But right now, that connection option is not supported yet:
https://doc.qt.io/qt-6/sql-driver.html#qodbc-for-open-database-connectivity-odbc
See the "connection options" section.
Attachments
| For Gerrit Dashboard: QTBUG-126118 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 577896,1 | SQL/ODBC: properly set SQL_ATTR_CURSOR_SCROLLABLE | tqtc/lts-6.5 | qt/tqtc-qtbase | Status: NEW | +2 | 0 |
| 570719,6 | SQL/ODBC: properly set SQL_ATTR_CURSOR_SCROLLABLE | dev | qt/qtbase | Status: MERGED | +2 | 0 |
| 574642,2 | SQL/ODBC: properly set SQL_ATTR_CURSOR_SCROLLABLE | 6.8 | qt/qtbase | Status: MERGED | +2 | 0 |
| 574917,3 | SQL/ODBC: properly set SQL_ATTR_CURSOR_SCROLLABLE | 6.7 | qt/qtbase | Status: MERGED | +2 | +1 |