[Solved]QSqlQuery does not work

AmirHammoutene

Hi everyone,

I try to add to my database a row but it does not work. My database is host by alwaysdata, I use Qt Creator to develop my program (which print no error) and MySql for viewing the database

via MySql Query Browser I entered :

@INSERT INTO mmr VALUES (NULL,'musictest','albumtest','timetest','datetest');@
it works but in my program that code does not work :
@
void MainWindow::b_clicked(){
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("mysql1.alwaysdata.com");
db.setDatabaseName("mymusicrecognition_mmr");
db.setUserName("xxx");
db.setPassword("yyyy");
if(!db.open())
{
QMessageBox::information(this,"Message","Not connected...");
}
else{

    QSqlQuery query;
    query.exec&#40;QString("INSERT INTO `mmr` VALUES (NULL,'%1','%2','%3','%4'&#41;"&#41;
    .arg("musictest").arg("albumtest").arg("timetest").arg("datetest"));
    QMessageBox::information(this,"Message","Connected !!!");
}

}@
I have the message box "Connected !!!"

This must be a beginner mistake

BlastDV

Hi, why do you say it doesn't work? You don't see the record on your table? Or does the application report an error message with the query?

By the way, I think you don't need the ' ' around the table name. I do INSERT queries like this:

@
InsertQuery->exec(QString("INSERT INTO actividad (usuario, tiempo, actividad) VALUES (")+QString("'")+UserID+QString("', '")+QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss")+QString("', ")+QString("'")+evento+QString("')"))
@

And they work!

Of course, the ".arg()" is ok, it depends on what you are trying to insert.

BlastDV

Reading your query again I found something weird beside what I told you about the ' ' around the table name.

Why are you using " " inside arg() ? If you are trying to insert string data (that would be varchar, I think), you should write your query like mine. On the other hand, if musictest, albumtest, timetest and datetest are other kinds of data like, let's say integers, you must not use " " for them inside arg().

AmirHammoutene

it does not work

BlastDV

Please can you be a little be more specific?

Is it prompting an error message? Are you getting database warnings? Is the .exec() returning and error? Is it that you don't see any change on the database?

AmirHammoutene

last one, no changes in database.
no error in the console

AmirHammoutene

ok i'm all wrong, I just discovered what is sqlite and I want to use MySql with database hosted on alwaysdata
thank u for your help anyway

BlastDV

I see. Don't worry, this is what the forum is about.

Please mark the thread as SOLVED by adding "[Solved]" before the title.