Qsql bindValue issue

[kaansef]

Hi,

My name is Kaan and I'm student. I writing a program and i was see an error. While i look generated SQL, i see blank SQL values. Please help me. (Sorry for my bad English.)

My code is here:

#include <QCoreApplication>
#include <QDebug>
#include <QSql>
#include <QSqlQuery>
#include <QSqlDatabase>
#include <QSqlError>
 
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QSqlDatabase database = QSqlDatabase::addDatabase("QSQLITE");
    database.setDatabaseName("C:/Veritabani.db");
    database.open();
    qDebug() << database.lastError();
    QSqlQuery query;
    query.prepare("INSERT INTO Users(username, e_mail, password) VALUES(:username, :e_mail, :password)");
    query.bindValue(":username", "Kaan");
    query.bindValue(":e_mail", "kaansef@gmail.com");
    query.bindValue(":password", "123456");
    query.exec();
    qDebug() << query.executedQuery();
    return a.exec();
}

#include <QCoreApplication>
#include <QDebug>
#include <QSql>
#include <QSqlQuery>
#include <QSqlDatabase>
#include <QSqlError>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QSqlDatabase database = QSqlDatabase::addDatabase("QSQLITE");
    database.setDatabaseName("C:/Veritabani.db");
    database.open();
    qDebug() << database.lastError();
    QSqlQuery query;
    query.prepare("INSERT INTO Users(username, e_mail, password) VALUES(:username, :e_mail, :password)");
    query.bindValue(":username", "Kaan");
    query.bindValue(":e_mail", "kaansef@gmail.com");
    query.bindValue(":password", "123456");
    query.exec();
    qDebug() << query.executedQuery();
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

[anda_skoa]

Does the database have a table calles "Users"?
Have you tried with columns names that do not contain the underscore character?

Cheers,
_

[Lesiok]

Test what query.exec() returns. If false then print on qDebug() query.lastError().

[kaansef]

Thanks for replies. query.lastError() returns "Parameter count mismatch".