Sum of a column in QSqlTableModel

[giusepped]

Is it possible to put a query like

SELECT SUM(column) FROM mytable

SELECT SUM(column) FROM mytable

To copy to clipboard, switch view to plain text mode 

inside a QSqlTableModel?
I woud get the sum of table without re-querying the database, because I already have the model...

[wysota]

Do you want it as a separate row or a separate column or how? I think the best way would be to use a proxy model.

[SunnySan]

This example may help

QSqlQuery query;
query.exec("SELECT MAX(id) FROM mytable");
	if (query.next()) {
		myStringResult = query.value(0).toString();
	}
query.finish();

QSqlQuery query;
query.exec("SELECT MAX(id) FROM mytable");
	if (query.next()) {
		myStringResult = query.value(0).toString();
	}
query.finish();

To copy to clipboard, switch view to plain text mode 

off course you need to replace the SQL code inside the .exec(_)

[giusepped]

Ok, but I would use some Qt model.
If I used a model to connect to the database, I would not to make an sql query.
There is a way to put compicated query inside the model?

G

[jacek]

You can use QSqlQueryModel.