[solved]Inserting values in QMysql

[killerman]

Hi. I've created a new Database called "people" and a new table in it called "table" with three columns (id, FirstName, LastName) but I have problem when i try to insert data in it.
The table already has 3 records;

Here is my programm :

#include <QCoreApplication>
#include <QDebug>
#include <QtSql>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("people");
db.setUserName("root");
db.setPassword("");

if(db.open()){
    qDebug() << "Opened";

    QString sQuery = "INSERT INTO table(id, FirstName, LastName) VALUES (:id, :FirstName, :LastName)";

    QSqlQuery qry;
    qry.prepare(sQuery);
    qry.bindValue(":id", 4);
    qry.bindValue(":FirstName", "Heather");
    qry.bindValue(":LastName", "Heather");

    qry.exec();

    qDebug() << "Closing";
    db.close();
}
else{
    qDebug() << "Whoops! ERRROR";
    qDebug() << db.lastError();
}

return a.exec(); 
}

It runs with no errors but nothing is added to the table...

[mcosta]

@killerman said:

qry.exec();

You should check the returned value of QSqlQuery::prepare() and QSqlQuery::exec()

[killerman]

i get false and false.

The connection to database is good because i can read from it...

[mcosta]

So it means you have error preparing the query.

Do this

bool result = qry.prepare(sQuery);
if (!result) {
    qDebug() << qry.lastError();
}

[killerman]

QSqlError("1064", "QMYSQL3: Unable to prepare statement", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table(id, FirstName, LastName)VALUES (?, ?, ?)' at line 1")

[mcosta]

@killerman said:

table

I'm not 100% sure you can use table as table name.
Anyway IIRC MySQL is case sensitive for table name if it runs on a case sensitive filesystem/OS (like Linux for example): check if the table name is correct

Try to run the same query from a different MySQL client to verify the syntax

[killerman]

I've made another DB and it works fine.

"table" was the problem. Thanks a lot :)

[mcosta]

You're welcome.

Remember to mark the thread as SOLVED