QSqlRelationalTableModel is messing things up after setting relation

[slobo_n]

Hi all.

First review the code that I'm using to create the tables.

void CreateTablesInSQLServer()
{
	QSqlQuery createGroupsTbl("CREATE TABLE grupa_tbl("
		"Grupa_Id int PRIMARY KEY IDENTITY(1,1) NOT NULL,"
		"GrupaName varchar(30) NOT NULL UNIQUE);");
 
 
	QSqlQuery createContactsTbl("CREATE TABLE contacts_tbl("
		"contact_id int PRIMARY KEY IDENTITY(1,1) NOT NULL,"
		"FirstName varchar(30) NULL,"
		"LastName varchar(40) NULL,"
		"Mobile varchar(40) NULL,"
		"Phone varchar(40) NULL,"		
		"GrupaId int NOT NULL,"		
		"FOREIGN KEY (GrupaId) REFERENCES grupa_tbl);");	
}

void CreateTablesInSQLServer()
{
	QSqlQuery createGroupsTbl("CREATE TABLE grupa_tbl("
		"Grupa_Id int PRIMARY KEY IDENTITY(1,1) NOT NULL,"
		"GrupaName varchar(30) NOT NULL UNIQUE);");


	QSqlQuery createContactsTbl("CREATE TABLE contacts_tbl("
		"contact_id int PRIMARY KEY IDENTITY(1,1) NOT NULL,"
		"FirstName varchar(30) NULL,"
		"LastName varchar(40) NULL,"
		"Mobile varchar(40) NULL,"
		"Phone varchar(40) NULL,"		
		"GrupaId int NOT NULL,"		
		"FOREIGN KEY (GrupaId) REFERENCES grupa_tbl);");	
}

To copy to clipboard, switch view to plain text mode 

After that I'm creating the model and populate the model with data.

QSqlRelationalTableModel *model = new QSqlRelationalTableModel;             //1
model->setTable("contacts_tbl");                                            //2
int i = model->fieldIndex("GrupaId");	                                    //3
model->setRelation(i, QSqlRelation("grupa_tbl", "Grupa_Id", "GrupaName"));  //4
QString TableName = model->tableName();                                     //5
model->select();                                                            //6
int k = model->fieldIndex("GrupaId");                                       //7
int y = model->fieldIndex("LastName");		                            //8
model->setTable("contacts_tbl");                                            //9
int h = model->fieldIndex("GrupaId");     //10

QSqlRelationalTableModel *model = new QSqlRelationalTableModel;             //1
model->setTable("contacts_tbl");                                            //2
int i = model->fieldIndex("GrupaId");	                                    //3
model->setRelation(i, QSqlRelation("grupa_tbl", "Grupa_Id", "GrupaName"));  //4
QString TableName = model->tableName();                                     //5
model->select();                                                            //6
int k = model->fieldIndex("GrupaId");                                       //7
int y = model->fieldIndex("LastName");		                            //8
model->setTable("contacts_tbl");                                            //9
int h = model->fieldIndex("GrupaId");     //10

To copy to clipboard, switch view to plain text mode 

This is the problem:
In line3 i can retrieve the field index for "GrupaId".
After i make the relation in line4 and i populate the model in line6, i cannot retrieve the field index for "GrupaId"(which is FOREIGN KEY) in line8. But i can get the field index for "LastName" and all of the rest columns.

If i call setTable in line9 i can retrieve the field index for "GrupaId", but as a result the relation in line4 is broken and i have to recreate it.

My goal is to retrieve the field index for "GrupaId" without calling

model->setTable("contacts_tbl");

model->setTable("contacts_tbl");

To copy to clipboard, switch view to plain text mode 

again and again.


Thanks in advance.

[slobo_n]

I found the solution to my problem. To get the index of "GrupaId" after setting the relation in line4 I need to refer to "GrupaName" like this:

int r = model->fieldIndex("GrupaName");