Changes to Qt SQL

Qt 6 is a result of the conscious effort to make the framework more efficient and easy to use.

We try to maintain binary and source compatibility for all the public APIs in each release. But some changes were inevitable in an effort to make Qt a better framework.

In this topic we summarize those changes in Qt SQL, and provide guidance to handle them.

The QSqlQuery class

boundValues() Signature

The return type for boundValues() has been changed from QMap<QString, QVariant> to a QVariantList. The order can be relied upon so it will be in the order of the binding in the prepared query. Change code like the following:

QMap<QString, QVariant> values = boundValues();
int id = values[":id"].value().toInt();
QList<QVariant> values = boundValues().values();
int id = values.at(0).toInt();

to:

QList<QVariant> values = boundValues().values();
int id = values.at(0).toInt();

© 2023 The Qt Company Ltd. Documentation contributions included herein are the copyrights of their respective owners. The documentation provided herein is licensed under the terms of the GNU Free Documentation License version 1.3 as published by the Free Software Foundation. Qt and respective logos are trademarks of The Qt Company Ltd. in Finland and/or other countries worldwide. All other trademarks are property of their respective owners.