SQL commande with QT

[Lesiok]

Where is query.exec() ?

[Ilumeo]

I didn't use any query.exec() untill now, that didn't seem necessary. Where should it be placed ?

[Lesiok]

1. Read more about QSqlQuery constructors.
2. It should be like this :

QSqlQuery query;
query.prepare("SELECT * FROM commandes WHERE id=(:id)");
query.bindValue(":id", id);
query.exec();

QSqlQuery query;
query.prepare("SELECT * FROM commandes WHERE id=(:id)");
query.bindValue(":id", id);
query.exec();

To copy to clipboard, switch view to plain text mode 

[Ilumeo]

Oh ok nice, from all the website I have looked over none talked about the prepare method, I guess my searching skill is not quite proefficient yet. Anyway Thank you that was really helpfull