Why are values ​​not substituted through bindValue in QSqlQuery?

Question

Qt

Hello! I'm trying to add data to the database via bindValue, however, the data is not being bound.
I do this:

if(query.prepare("INSERT INTO messages (date, time, username, phone_number, text_message) VALUES (:date, :time, :name, :phone, :text)"))
    {
        query.bindValue(":date","1");
        query.bindValue(":time","1");
        query.bindValue(":name","1");
        query.bindValue(":phone","1");
        query.bindValue(":text","1");
        qDebug()<<query.lastError();
        query.exec();
}

then through
qDebug()<<query.executedQuery();
I look request. And I see this:

"INSERT INTO messages (date, time, username, phone_number, text_message) VALUES (?, ?, ?, ?, ?)"

I also output this:
qDebug()<<query.boundValues();
I see this:

QMap((":date", QVariant(QString, "1"))(":name", QVariant(QString, "1"))(":phone", QVariant(QString, "1"))(": text", QVariant(QString, "1"))(":time", QVariant(QString, "1")))

Question: why are values ​​not inserted into the request text through bindValue, but question marks remain?

Answer 1

query.executedQuery() won't show the real query, try this:

QString lastQuery = query.executedQuery();
    for (int i = 0, j = 0; j < query.boundValues().size(); ++j)
    {
        i = lastQuery.indexOf(QLatin1Char('?'), i);
        if (i <= 0)  break;
        const QVariant& var = query.boundValue(j);
        QSqlField field(QString(""), var.type());
        if (var.isNull())  field.clear();
        else  field.setValue(var);
        QString formatV = query.driver()->formatValue(field);
        lastQuery.replace(i, 1, formatV);
        i += formatV.length();
    }
qDebug()<<"SQL Query error:"<<lastQuery;

Answer 2

bool ok = query.prepare("INSERT INTO messages (date, time, username, phone_number, text_message) VALUES (:date, :time, :name, :phone, :text)");
query.bindValue(":date","1");
query.bindValue(":time","1");
query.bindValue(":name","1");
query.bindValue(":phone","1");
query.bindValue(":text","1");

if (ok)
    query.exec();
else
    qDebug()<<query.lastError();

Answer 3

Make an else branch after prepare and display query.lastError() via qDebug() and see what it says to you.