SQL query

[JD2000]

I had assumed that something along the lines of

QSqlQueryModel *model = new QSqlQueryModel(this);
QSqlQuery query;
query.prepare("INSERT INTO INSERT INTO people(ID,Name,Age) VALUES (?, ?, ?)");
query.addBindValue(1);
query.addBindValue("Fred Bloggs");
query.addBindValue(21);
model->setQuery(query);

QSqlQueryModel *model = new QSqlQueryModel(this);
QSqlQuery query;
query.prepare("INSERT INTO INSERT INTO people(ID,Name,Age) VALUES (?, ?, ?)");
query.addBindValue(1);
query.addBindValue("Fred Bloggs");
query.addBindValue(21);
model->setQuery(query);

To copy to clipboard, switch view to plain text mode 

would do the trick but 'query.lastQuery()' seems to indicate that the values are not being bound.

[JD2000]

Thanks montuno,

I'll try the the QSqlTableModel you suggest.

[JD2000]

Actually I've discovered that the following works!

QSqlQuery query;
query.prepare("INSERT INTO INSERT INTO people(ID,Name,Age) VALUES (?, ?, ?)");
query.addBindValue(1);
query.addBindValue("Fred Bloggs");
query.addBindValue(21);
query.exec();
model->setQuery("SELECT * FROM clients ORDER BY clientName");

QSqlQuery query;
query.prepare("INSERT INTO INSERT INTO people(ID,Name,Age) VALUES (?, ?, ?)");
query.addBindValue(1);
query.addBindValue("Fred Bloggs");
query.addBindValue(21);
query.exec();
model->setQuery("SELECT * FROM clients ORDER BY clientName");

To copy to clipboard, switch view to plain text mode