[SOLVED]How to update QSqlRelationalTableModel internal model?



  • Hi,

    I will try to explain the problem with the following scenario:

    Suppose we have two tables A and B, table B has a Foreign key column from A and we applied QSqlRelation to that column, now we insert/update a row in table A.

    The problem is that the QSqlRelation still see the old A table, how can i update the relation.?

    Appreciate any kind of help.



  • I tried to call myRelationalTableModel.relationModel(columnIndex).select() after saving changes to table A, but this doesn't solve the problem.

    Serious help needed, please.. :)



  • Help, Help, Help..!!!

    If this problem doesn't have a direct solution, please moderators just tell me..



  • Finally Solved,,

    it was a bug in PyQt4 until version 4.9.5-1, all you have to do is re-select the relation model, like this:

    QSqlRelationalTableModel.relationModel(columnIndex).select()


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.