Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Empty qsqlrelationaltablemodel
Forum Updated to NodeBB v4.3 + New Features

Empty qsqlrelationaltablemodel

Scheduled Pinned Locked Moved General and Desktop
1 Posts 1 Posters 409 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    Charlie42
    wrote on last edited by
    #1

    When I put model->select(); after relations, the model is empty, when I put it back before relations, the table displays correctly, but when I edit any cell the whole row becomes empty and gets "!" on the left. No errors.

    QSqlRelationalTableModel *model = new QSqlRelationalTableModel(this, db1);
    model->setTable("syllabi");
    model->setEditStrategy(QSqlTableModel::OnFieldChange);
    model->select();
    model->setRelation(3, QSqlRelation("activity_types", "activity_type_id", "activity_type_name"));
    model->setRelation(0, QSqlRelation("teachers", "teacher_id", "teacher_name"));
    //model->select();
    qDebug() << model->lastError();
    
    ui->tableView->setModel(model);
    ui->tableView->setItemDelegate(new QSqlRelationalDelegate(ui->tableView));
    ui->tableView->horizontalHeader()->setStretchLastSection(true);
    ui->tableView->setColumnHidden(9, true);
    
    1 Reply Last reply
    0

    • Login

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Get Qt Extensions
    • Unsolved