QSqlRelationalTableModel query question

[cyberboy]

Hi,

I'm currently busy with a SQLite database, and I have a question.

I have two tables, clients and orders, the orders table has to be populated in the QSqlRelationalTableModel. But the client information has to be added to the row.

So the first thing I did was is setRelation(clientId, "cid", "First Name"); (with clientId as columnIndex from the orders table) and it works, but I need more client information than the first name.

How can I solve such a problem?

Kind regards,

Marcel Boersma

[cyberboy]

I've found a solution, right now I'm using a QSqlQueryModel so I can combine some queries.

But now I have another problem(A)

Some code snippets:

mainWindow::mainWindow(QWidget *parent){
        //create model
	QSqlQueryModel *orderModel = new QSqlQueryModel;
 
       //setQueryCritics
       	this->setQueryCritics(orderModel, 1);
}
 
void mainWindow::setQueryCritics(QSqlQueryModel &model, int type)
{
 
	QSqlQuery query;
	query.prepare("SELECT c.*, o.* FROM clients AS c, orders AS o WHERE o.oid = c.cid and o.currentStatus = :status ");
 
	switch(type){
	case 1 :
		//orderModel
		query.bindValue(":status", "1");
	break;
	case 2 :
		//finishModel
		query.bindValue(":status", "2");
	break;
	case 3 :
		//trashModel
		query.bindValue(":status", "3");
	break;
	case 4 :
		//clientModel
		query.prepare("SELECT * FROM clients");
	break;
	}
 
	model.setQuery(query);
 
 
 
}

mainWindow::mainWindow(QWidget *parent){
        //create model
	QSqlQueryModel *orderModel = new QSqlQueryModel;

       //setQueryCritics
       	this->setQueryCritics(orderModel, 1);
}

void mainWindow::setQueryCritics(QSqlQueryModel &model, int type)
{
	
	QSqlQuery query;
	query.prepare("SELECT c.*, o.* FROM clients AS c, orders AS o WHERE o.oid = c.cid and o.currentStatus = :status ");
	
	switch(type){
	case 1 :
		//orderModel
		query.bindValue(":status", "1");
	break;
	case 2 :
		//finishModel
		query.bindValue(":status", "2");
	break;
	case 3 :
		//trashModel
		query.bindValue(":status", "3");
	break;
	case 4 :
		//clientModel
		query.prepare("SELECT * FROM clients");
	break;
	}

	model.setQuery(query);
	

	
}

To copy to clipboard, switch view to plain text mode 

and here is the error message I get:

mainWindow.cpp:37: error: no matching function for call to 'mainWindow::setQueryCritics(QSqlQueryModel*&, int)'

I hope and I think it's a real simple problem, but I don't see the solution
Can somebody help me with this?

Kind regards,

Cyberboy

[jpn]

Your function takes a reference but you try to pass a pointer.

[cyberboy]

all-right, how can I edit the query of the model I pass in the function?
Do I have to pass a pointer or a reference?

[jpn]

Well, this is a basic C++ issue, but let's say that you might want to alter the function to take a pointer...