How to remove a record from a table with a composed primary key using QModelIndex ?

[nagpalma]

Hello,

How to remove a record from a table with a composed primary key using QModelIndex and removeRow?

In tables with simple primary key (just one column) it works fine with:

QModelIndex index = sequenceTableView->currentIndex();
    if (!index.isValid())
        return;
    sequenceModel->removeRow(index.row());
    }

QModelIndex index = sequenceTableView->currentIndex();
    if (!index.isValid())
        return;
    sequenceModel->removeRow(index.row());
    }

To copy to clipboard, switch view to plain text mode 

but with 2 columns (with similar code) i can't delete the record and in the output window appears the message:

QSqlQuery::value: not positioned on a valid record


Any help would be appreciated.
Thanks,
Palma

[nagpalma]

the problem is solved, the index was returning wrong types. I was pretending to remove a row from a QSqlRelationalTableModel whose index is formed by two fields that are foreign keys, and the index was returning the names instead of the ids....

[pcheng]

Can you please provide some input on how you solved this problem?

Thanks,

Pericles