Problem with QModelIndex

[Kesy]

Hi everybody, I'm writing a program with QT 4.4
I'm writing a program to read email from a SQLite database, I used a QSqlQueryModel and a QTableView, when I select a row of the table it returns a QModelIndex

connect(myTable, SIGNAL(clicked(QModelIndex)),myTextBrowser, SLOT(dispayMail(QModelIndex)));

connect(myTable, SIGNAL(clicked(QModelIndex)),myTextBrowser, SLOT(dispayMail(QModelIndex)));

To copy to clipboard, switch view to plain text mode 

I want that instead a QModelIndex it returns the email id, or else, how i get the email id from the QModelIndex?

Here is the code: (just a part of it, if you need more I will post it)

QSqlQuery query("SELECT email.id,addresses.name,email.subject,email.date FROM email,addresses WHERE addresses.id=email.'from'");
	model = new QSqlQueryModel;
	model->setQuery(query);
        model->removeColumn(0); // don't show the ID
        model->setHeaderData(0, Qt::Horizontal, tr("Da"));
        model->setHeaderData(1, Qt::Horizontal, tr("Soggetto"));
	model->setHeaderData(2, Qt::Horizontal, tr("Data"));
 
	this->setShowGrid(FALSE);
	this->verticalHeader()->hide();
	this->setEditTriggers(QAbstractItemView::NoEditTriggers);
	this->setSelectionMode(QAbstractItemView::ContiguousSelection);
	this->setSelectionBehavior(QAbstractItemView::SelectRows);
        this->setSelectionMode(QAbstractItemView::ExtendedSelection);
	this->setModel(model);
        this->show();

QSqlQuery query("SELECT email.id,addresses.name,email.subject,email.date FROM email,addresses WHERE addresses.id=email.'from'");
	model = new QSqlQueryModel;
	model->setQuery(query);
        model->removeColumn(0); // don't show the ID
        model->setHeaderData(0, Qt::Horizontal, tr("Da"));
        model->setHeaderData(1, Qt::Horizontal, tr("Soggetto"));
	model->setHeaderData(2, Qt::Horizontal, tr("Data"));
	
	this->setShowGrid(FALSE);
	this->verticalHeader()->hide();
	this->setEditTriggers(QAbstractItemView::NoEditTriggers);
	this->setSelectionMode(QAbstractItemView::ContiguousSelection);
	this->setSelectionBehavior(QAbstractItemView::SelectRows);
        this->setSelectionMode(QAbstractItemView::ExtendedSelection);
	this->setModel(model);
        this->show();

To copy to clipboard, switch view to plain text mode 

Thanks

Ps: Sorry for my english, but I'm swiss

[spirit]

QString email = index.data(Qt::EditRole).toString();

QString email = index.data(Qt::EditRole).toString();

To copy to clipboard, switch view to plain text mode 

PS. please, use tags code.

[Kesy]

QString email = index.data(Qt::EditRole).toString();

QString email = index.data(Qt::EditRole).toString();

To copy to clipboard, switch view to plain text mode 

PS. please, use tags code.

Thanks a lot for the quick answer.
If I use your code I get the content of the cell I clicked, but I want get the Id (from the database) of the row I clicked
this is the table

Da | Soggetto | Data

and this is the query

QSqlQuery query("SELECT email.id,addresses.name,email.subject,email.date FROM email,addresses WHERE addresses.id=email.'from'");

QSqlQuery query("SELECT email.id,addresses.name,email.subject,email.date FROM email,addresses WHERE addresses.id=email.'from'");

To copy to clipboard, switch view to plain text mode 

I just don't display the id in the QTableView

Thanks

[spirit]

then try this

...
if (!index.isValid())
   return;
 
QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field
 
int id = index.data(Qt::EditRole).toInt(); 
...

...
if (!index.isValid())
   return;

QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field

int id = index.data(Qt::EditRole).toInt(); 
...

To copy to clipboard, switch view to plain text mode 

or you also can determinate id column by name and then pass it in method index.
it's just an example/

[spirit]

or you can use this method

QSqlRecord QSqlQueryModel::record ( int row ) const

if (!index.isValid())
   return;
 
int id = qobject_cast<QSqlTableModel *>(index.model())->record(index.row()).value("email.id").toInt();

if (!index.isValid())
   return;

int id = qobject_cast<QSqlTableModel *>(index.model())->record(index.row()).value("email.id").toInt();

To copy to clipboard, switch view to plain text mode 

[Kesy]

Thanks a lot man, you are a genius
I used this

...
if (!index.isValid())
   return;
 
QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field
 
int id = index.data(Qt::EditRole).toInt(); 
...

...
if (!index.isValid())
   return;
 
QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field
 
int id = index.data(Qt::EditRole).toInt(); 
...

To copy to clipboard, switch view to plain text mode 

and it worked fine.

[spirit]

Thanks a lot man, you are a genius
I used this

...
if (!index.isValid())
   return;
 
QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field
 
int id = index.data(Qt::EditRole).toInt(); 
...

...
if (!index.isValid())
   return;
 
QModelIndex idx;
if (!index.column())
   idx = index;
else
   idx = index.model()->index(0, index.row());//0 -- id field
 
int id = index.data(Qt::EditRole).toInt(); 
...

To copy to clipboard, switch view to plain text mode 

and it worked fine.

you are wellcome. but I suggest you to use code from my last post, it is more clear to use (for this task), but in general case this one more preferred.