QSqlQuery::prepare() and executed sql command after bound values

[estanisgeyer]

Post your sample code, please. But, the basic is:

int i = 10;
QSqlQuery q;
QSqlRecord r;
q.prepare(QString::fromUtf8(" SELECT ID_EXAMPLE, FIELD_EXAMPLE FROM TABLE_EXAMPLE WHERE ID_EXAMPLE = ? ");
q.addBindValue(i);
q.exec();
r = q.record();
QString s = q.value(r.indexOf("FIELD_EXAMPLE")).toString();

int i = 10;
QSqlQuery q;
QSqlRecord r;
q.prepare(QString::fromUtf8(" SELECT ID_EXAMPLE, FIELD_EXAMPLE FROM TABLE_EXAMPLE WHERE ID_EXAMPLE = ? ");
q.addBindValue(i);
q.exec();
r = q.record();
QString s = q.value(r.indexOf("FIELD_EXAMPLE")).toString();

To copy to clipboard, switch view to plain text mode