PDA

View Full Version : Qsql bindValue issue



kaansef
4th May 2016, 22:55
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();
}

anda_skoa
5th May 2016, 11:35
Does the database have a table calles "Users"?
Have you tried with columns names that do not contain the underscore character?

Cheers,
_

Lesiok
5th May 2016, 12:28
Test what query.exec() returns. If false then print on qDebug() query.lastError().

kaansef
5th May 2016, 12:57
Thanks for replies. query.lastError() returns "Parameter count mismatch".