Results 1 to 3 of 3

Thread: QTableView QTablemodel & insertRow

  1. 5th June 2007, 08:15 #1
    pfusterschmied
    pfusterschmied is offline Beginner
    Join Date
    Jun 2007
    Posts
    3
    Thanks
    1
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default QTableView QTablemodel & insertRow

    Hi,

    I want to show Data from a Relational DB in a QTableView.
    This work fine, also the editing about OnManualSubmit works. Now I want to add and delete Rows in the QTableView. When I tray to add a row an error occurs:

    Segmentation fault (core dumped)
    *** Exited with status: 139 ***

    What does this error means?

    I think its a memory lack but I don't know what to do?
    I work on Ubuntu Feisty, QT 4.2.3, KDevelop 3.4

    Qt Code: 
    1. #include <QtGui> 
    2. #include <QtSql> 
    3. #include <QDebug> 
    4. #include "tablemodel.h" 
    5.  
    6. tableModel::tableModel() 
    7. { 
    8.  
    9.    QPushButton *submitPb = new QPushButton(QObject::trUtf8("Änderungen speichern")); 
    10.    QPushButton *revertPb = new QPushButton(QObject::trUtf8("Änderungen verwerfen")); 
    11.    QPushButton *addPb = new QPushButton(QObject::trUtf8("Neue Person")); 
    12.    QPushButton *deletePb = new QPushButton(QObject::trUtf8("Lösche Person")); 
    13.  
    15.    model->setTable("tx_submission_data"); 
    16.    model->setRelation(28,QSqlRelation("tx_submission_epterm","uid", "epterm")); 
    17.    model->setRelation(29,QSqlRelation("tx_submission_status","uid", "status")); 
    18.    model->setRelation(30,QSqlRelation("tx_submission_status","uid", "status")); 
    19.    model->setRelation(31,QSqlRelation("tx_submission_status","uid", "status")); 
    20.    model->setRelation(32,QSqlRelation("tx_submission_status","uid", "status")); 
    21.    model->setRelation(33,QSqlRelation("tx_submission_status","uid", "status")); 
    22.    model->setRelation(34,QSqlRelation("tx_submission_status","uid", "status")); 
    23.    model->setEditStrategy(QSqlTableModel::OnManualSubmit); 
    24.  
    25.  
    26.    model->removeColumns(1,7); 
    27.    model->removeColumn(5); 
    28.    model->removeColumn(6); 
    29.    model->removeColumn(6); 
    30.    model->removeColumn(6); 
    31.    model->removeColumn(7); 
    32.    model->removeColumn(7); 
    33.    model->removeColumn(7); 
    34.    model->removeColumn(7); 
    35.    model->removeColumn(7); 
    36.    model->removeColumn(7); 
    37.    model->removeColumn(7); 
    38.    model->removeColumn(8); 
    39.    model->removeColumn(11); 
    40.  
    41.    model->select(); 
    42.  
    43.    QTableView *viewTable = new QTableView; 
    44.    viewTable->setModel(model); 
    45.    viewTable->setItemDelegate(new QSqlRelationalDelegate(this)); 
    46.    viewTable->setSortingEnabled(TRUE); 
    47.    viewTable->setAlternatingRowColors(TRUE); 
    48.    //viewTable->hideColumn(0);    
    49.    viewTable->setSelectionMode(QAbstractItemView::SingleSelection); 
    50.    viewTable->setSelectionBehavior(QAbstractItemView::SelectRows); 
    51.    viewTable->resizeColumnsToContents(); 
    52.  
    53.    connect(submitPb, SIGNAL(clicked(bool)), model, SLOT(submitAll()) ); 
    54.    connect(revertPb, SIGNAL(clicked(bool)), model, SLOT(revertAll() ) ); 
    55.  
    56.    connect(addPb, SIGNAL(clicked(bool)), this, SLOT(addPerson() ) ); 
    57.    connect(deletePb, SIGNAL(clicked(bool)), this, SLOT(deletePerson() ) ); 
    58.  
    59.    QGridLayout *lay = new QGridLayout(this); 
    60.    lay->addWidget(viewTable, 0, 0, 1, 4); 
    61.    lay->addWidget(submitPb, 1, 0); 
    62.    lay->addWidget(revertPb, 1, 1); 
    63.    lay->addWidget(addPb, 1, 2); 
    64.    lay->addWidget(deletePb, 1, 3); 
    65.  
    66.    // CSS 
    67.    qApp->setStyleSheet("QTableView {background-color: #eeeeee; background-image: url(:/bg.png); color: blue;}"); 
    68. } 
    69.  
    70. void tableModel::addPerson() 
    71. { 
    72.    int row = model->rowCount();
    73. 	model->insertRow(row);
    74. 	QModelIndex index = model->index(row, Person_Name);
    75. 	viewTable->setCurrentIndex(index);
    76. 	viewTable->edit(index);
    77.  
    78.    QMessageBox::warning(this, trUtf8("Person hinzufügen"), trUtf8("Sie müssen alle Felder ausfüllen!") ); 
    79. } 
    80.  
    81. void tableModel::deletePerson() 
    82. { 
    83.  
    84. } 
    85.  
    86.  
    87.  
    88. tableModel::~tableModel() 
    89. { 
    90.  
    91. }
    To copy to clipboard, switch view to plain text mode 

    Person_Name = 1 (Column with persons name)
    Reply With Quote Reply With Quote
  2. 5th June 2007, 10:04 #2
    steg90
    steg90 is offline Advanced user
    Join Date
    May 2007
    Posts
    301
    Thanks
    46
    Thanked 3 Times in 3 Posts
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QTableView QTablemodel & insertRow

    Could you not just do :

    Qt Code: 
    1. int row = model->rowCount();
    2. QModelIndex index = model->index(row, Person_Name);
    3. beginInsertRows(index, row, row );
    4.  
    5. // insert your data
    6.  
    7. endInsertRows();
    To copy to clipboard, switch view to plain text mode 

    Regards,
    Steve
    Reply With Quote Reply With Quote

  3. The following user says thank you to steg90 for this useful post:

    pfusterschmied (5th June 2007)
  4. 5th June 2007, 12:43 #3
    pfusterschmied
    pfusterschmied is offline Beginner
    Join Date
    Jun 2007
    Posts
    3
    Thanks
    1
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: QTableView QTablemodel & insertRow

    Found solution:

    Qt Code: 
    1. QTableView *viewTable = new QTableView;
    To copy to clipboard, switch view to plain text mode 
    doesn't work but:
    Qt Code: 
    1. viewTable = new QTableView;
    To copy to clipboard, switch view to plain text mode 
    because I defined this in header...

    Thanks for the Code steg90 this is a good way too.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.