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. QStandardItemModel doesn't display data
Forum Updated to NodeBB v4.3 + New Features

QStandardItemModel doesn't display data

Scheduled Pinned Locked Moved Solved General and Desktop
23 Posts 5 Posters 8.4k Views 4 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.
  • G Offline
    G Offline
    gabor53
    wrote on last edited by
    #1

    Hi,
    I'm using QStandardItemModel to display the contents of a db in TableView. The following code produces no error messages, but doesn't display anything though an other version of the same code works well.

    void FixDb::correctFriend()
{
    qDebug() << "Entered correctFriend!";

    QSqlQuery query_fix  ("SELECT * FROM Items ORDER BY NAME ASC ");

    if(query_fix.isActive()==true)
        {
            qDebug() << "The query_fix is active.";
        }
    else
        {
            qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
        }



    QStandardItemModel *fixmodel = new QStandardItemModel(this);
    ui->tableView_fix->setModel (fixmodel);

    for(int row1 = 1; query_fix.next (); row1++)
        {
            if(row1 == 0)
                {
                    const QSqlRecord qR = query_fix.record ();
                    qDebug() << "The number of records: " << qR;
                    fixmodel->insertColumns (0, qR.count());
                }
            fixmodel->insertRow (row1);
            fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString ());
            fixmodel->setData (fixmodel->index(row1,1),query_fix.value (1).toString ());
            fixmodel->setData (fixmodel->index(row1,2),query_fix.value (13).toString ());

            fixPixmap.loadFromData (query_fix.value (2).toByteArray ());
            fixPixmap = fixPixmap.scaled (100,100,Qt::KeepAspectRatio);

            fixmodel->setData (fixmodel->index (row1,3),fixPixmap,Qt::DecorationRole);
            fixmodel->setData (fixmodel->index(row1,4),query_fix.value (11).toString ());
            fixmodel->setData (fixmodel->index(row1,5),query_fix.value (10).toString ());
            fixmodel->setData (fixmodel->index(row1,6),query_fix.value (3).toString ());

            monthf = query_fix.value (4).toString ();
            dayf = query_fix.value (5).toString ();
            yearf = query_fix.value (6).toString ();
            date = monthf + "/" + dayf + "/" + yearf;

            fixmodel->setData (fixmodel->index(row1,5),date);
            fixmodel->setData (fixmodel->index(row1,6),query_fix.value (12).toString ());
            fixmodel->setData (fixmodel->index(row1,7),query_fix.value (7).toString ());
            fixmodel->setData (fixmodel->index(row1,8),query_fix.value (8).toString ());
            fixmodel->setData (fixmodel->index(row1,9),query_fix.value (9).toString ());
            ui->tableView_fix->setRowHeight (row1,100);
        }

    ui->tableView_fix->horizontalHeader ()->setStyleSheet ("QHeaderView{font: 14pt Arial; color: blue; font-weight: bold;}");
    ui->tableView_fix->verticalHeader ()->setVisible (false);
    ui->tableView_fix->setAlternatingRowColors (true);
    ui->tableView_fix->setStyleSheet ("alternate-background-color: rgb(224,255,248); background-color: white; font: 14pt Arial");
    ui->tableView_fix->setEditTriggers (QAbstractItemView::CurrentChanged);
    fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));
    fixmodel->setHeaderData (1,Qt::Horizontal, QObject::tr("Name"));
    fixmodel->setHeaderData (2,Qt::Horizontal, QObject::tr("What is the Friend?"));
    fixmodel->setHeaderData (3,Qt::Horizontal, QObject::tr("The Friend's Picture"));
    fixmodel->setHeaderData (4,Qt::Horizontal, QObject::tr("Material"));
    fixmodel->setHeaderData (5,Qt::Horizontal, QObject::tr("Color"));
    fixmodel->setHeaderData (6,Qt::Horizontal, QObject::tr("Description"));
    fixmodel->setHeaderData (7,Qt::Horizontal, QObject::tr("Adoption Date"));
    fixmodel->setHeaderData (8,Qt::Horizontal, QObject::tr("Signed by"));
    fixmodel->setHeaderData (9,Qt::Horizontal, QObject::tr("History"));
    fixmodel->setHeaderData (10,Qt::Horizontal, QObject::tr("Age"));
    fixmodel->setHeaderData (11,Qt::Horizontal, QObject::tr("Notes"));

    ui->tableView_fix->setColumnWidth (0,1);
    ui->tableView_fix->setColumnWidth (1,200);
    ui->tableView_fix->setColumnWidth (2,200);
    ui->tableView_fix->setColumnWidth (3,90);
    ui->tableView_fix->setColumnWidth (4,200);
    ui->tableView_fix->setColumnWidth (5,200);
    ui->tableView_fix->setColumnWidth (6,350);
    ui->tableView_fix->setColumnWidth (7,200);
    ui->tableView_fix->setColumnWidth (8,200);
    ui->tableView_fix->setColumnWidth (9,350);
    ui->tableView_fix->setColumnWidth (10,200);
    ui->tableView_fix->setColumnWidth (11,350);
    ui->tableView_fix->setWordWrap (true);

}

    Please tell me what's wrong with it. Thank you.

    1 Reply Last reply
    0
    • M Offline
      M Offline
      mjsurette
      wrote on last edited by
      #2

      I don't see any errors, but I do have a suggestion to use QSqlTableModel so you don't have to transfer the data yourself. It will simplify the code.

      In my experience nothing displayed in your view is usually caused by a query gone wrong, but that should be printed in your lastError(). You don't show the output of your qDebug()s so I have to assume everything is normal there.

      Is your default database initialised properly?

      What version of Qt worked and what version doesn't?

      Mike

      G 1 Reply Last reply
      2
      • M mjsurette

        I don't see any errors, but I do have a suggestion to use QSqlTableModel so you don't have to transfer the data yourself. It will simplify the code.

        In my experience nothing displayed in your view is usually caused by a query gone wrong, but that should be printed in your lastError(). You don't show the output of your qDebug()s so I have to assume everything is normal there.

        Is your default database initialised properly?

        What version of Qt worked and what version doesn't?

        Mike

        G Offline
        G Offline
        gabor53
        wrote on last edited by
        #3

        @mjsurette
        I initialize the db when the program starts in main.cpp like this:

            QSqlDatabase db;
    QString fileQstring = "C:/Programming/Projects/FolkFriends_1_0/db.db";

    db = QSqlDatabase::addDatabase ("QSQLITE");
    db.setDatabaseName (fileQstring);
    qDebug() << "Connection Display created in main.cpp. ";

    bool OK = db.open ();

    if(OK == true)
        {
            qDebug() << "The db (MainWindow) is open!";
        }
    else
        {
            qDebug() << "The db (MainWindow) is not open!";
        }

    if(!db.open ())
        {
            qDebug() << "The database (db) is NOT open!" << db.lastError ();

        }

        The connection works at other places.
        Last error displays no error. I used the same Qt version (Qt 5.7) throughout the program.

        1 Reply Last reply
        0
        • Pradeep KumarP Offline
          Pradeep KumarP Offline
          Pradeep Kumar
          wrote on last edited by
          #4

          Hi,

          can u check few things,

          1. Is db opened succesfully.
          2. values are present in dB of the respective tables.
          3. while retreiving provide qDebug() statements, so u can verify the data.
          4. Check the table name which u have provided,is it correct?.

          Thanks,

          Pradeep Kumar
          Qt,QML Developer

          1 Reply Last reply
          2
          • Pradeep KumarP Offline
            Pradeep KumarP Offline
            Pradeep Kumar
            wrote on last edited by
            #5

            Construct the model and then add it to view.

            Pradeep Kumar
            Qt,QML Developer

            G 1 Reply Last reply
            1
            • SGaistS Offline
              SGaistS Offline
              SGaist
              Lifetime Qt Champion
              wrote on last edited by
              #6

              Hi,

              You're trying to open your database twice which is wrong.

              Did you check that you are indeed passing in your loop ? Note that your first test will never pass since row1 is initialized at 1.

              Interested in AI ? www.idiap.ch
              Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

              1 Reply Last reply
              2
              • Pradeep KumarP Pradeep Kumar

                Construct the model and then add it to view.

                G Offline
                G Offline
                gabor53
                wrote on last edited by
                #7

                @Pradeep-Kumar
                Hi,
                It has data. I added

                 qDebug() << "ID in fix: " << query_fix.value (0).toString ();

                and I got the following:
                ID in fix: "4"
                ID in fix: "1"
                ID in fix: "3"
                ID in fix: "2"
                which is exactly what supposed to be there. It just doesn't show up in the table.

                1 Reply Last reply
                0
                • SGaistS Offline
                  SGaistS Offline
                  SGaist
                  Lifetime Qt Champion
                  wrote on last edited by
                  #8

                  You don't set any column count. That's something you have to set either at construction time or before you start adding rows/data.

                  Interested in AI ? www.idiap.ch
                  Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                  1 Reply Last reply
                  2
                  • Pradeep KumarP Offline
                    Pradeep KumarP Offline
                    Pradeep Kumar
                    wrote on last edited by Pradeep Kumar
                    #9

                    void FixDb::correctFriend()
                    {
                    qDebug() << "Entered correctFriend!";

                    QSqlQuery query_fix  ("SELECT * FROM Items ORDER BY NAME ASC ");

if(query_fix.isActive()==true)
    {
        qDebug() << "The query_fix is active.";
    }
else
    {
        qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
    }



QStandardItemModel *fixmodel = new QStandardItemModel(this);
fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));
fixmodel->setHeaderData (1,Qt::Horizontal, QObject::tr("Name"));
fixmodel->setHeaderData (2,Qt::Horizontal, QObject::tr("What is the Friend?"));
fixmodel->setHeaderData (3,Qt::Horizontal, QObject::tr("The Friend's Picture"));
fixmodel->setHeaderData (4,Qt::Horizontal, QObject::tr("Material"));
fixmodel->setHeaderData (5,Qt::Horizontal, QObject::tr("Color"));
fixmodel->setHeaderData (6,Qt::Horizontal, QObject::tr("Description"));
fixmodel->setHeaderData (7,Qt::Horizontal, QObject::tr("Adoption Date"));
fixmodel->setHeaderData (8,Qt::Horizontal, QObject::tr("Signed by"));
fixmodel->setHeaderData (9,Qt::Horizontal, QObject::tr("History"));
fixmodel->setHeaderData (10,Qt::Horizontal, QObject::tr("Age"));
fixmodel->setHeaderData (11,Qt::Horizontal, QObject::tr("Notes"));
fixmodel->setColumnCount(12);		// as per your column header its 11							
	
ui->tableView_fix->horizontalHeader ()->setStyleSheet ("QHeaderView{font: 14pt Arial; color: blue; font-weight: bold;}");
ui->tableView_fix->verticalHeader ()->setVisible (false);
ui->tableView_fix->setAlternatingRowColors (true);
ui->tableView_fix->setStyleSheet ("alternate-background-color: rgb(224,255,248); background-color: white; font: 14pt Arial");
ui->tableView_fix->setEditTriggers (QAbstractItemView::CurrentChanged);

ui->tableView_fix->setColumnWidth (0,100);
ui->tableView_fix->setColumnWidth (1,200);
ui->tableView_fix->setColumnWidth (2,200);
ui->tableView_fix->setColumnWidth (3,90);
ui->tableView_fix->setColumnWidth (4,200);
ui->tableView_fix->setColumnWidth (5,200);
ui->tableView_fix->setColumnWidth (6,350);
ui->tableView_fix->setColumnWidth (7,200);
ui->tableView_fix->setColumnWidth (8,200);
ui->tableView_fix->setColumnWidth (9,350);
ui->tableView_fix->setColumnWidth (10,200);
ui->tableView_fix->setColumnWidth (11,350);
ui->tableView_fix->setWordWrap (true);


for(int row1 = 0; query_fix.next(); ++row1)
    {
 fixmodel->setRowCount(row1);
 fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString());			// oth column value
 fixmodel->setData (fixmodel->index(row1,1),query_fix.value (1).toString ());			// 1th column value	
fixmodel->setData (fixmodel->index(row1,2),query_fix.value (13).toString ());			// 13th column value

 fixPixmap.loadFromData (query_fix.value (2).toByteArray ());					// 2th column value	
 fixPixmap = fixPixmap.scaled (100,100,Qt::KeepAspectRatio);

 fixmodel->setData (fixmodel->index (row1,3),fixPixmap,Qt::DecorationRole);
fixmodel->setData (fixmodel->index(row1,4),query_fix.value (11).toString ());			// 11th column value	
fixmodel->setData (fixmodel->index(row1,5),query_fix.value (10).toString ());			// 10th column value	
 fixmodel->setData (fixmodel->index(row1,6),query_fix.value (3).toString ());			// 3th column value

        monthf = query_fix.value (4).toString ();								// 4th column value
        dayf = query_fix.value (5).toString ();								// 5th column value	
        yearf = query_fix.value (6).toString ();								// 6th column value
        date = monthf + "/" + dayf + "/" + yearf;	

fixmodel->setData (fixmodel->index(row1,5),date);
fixmodel->setData (fixmodel->index(row1,6),query_fix.value (12).toString ());			// 12th column value
fixmodel->setData (fixmodel->index(row1,7),query_fix.value (7).toString ());			// 7th column value
fixmodel->setData (fixmodel->index(row1,8),query_fix.value (8).toString ());			// 8th column value	
fixmodel->setData (fixmodel->index(row1,9),query_fix.value (9).toString ());			// 9th column value

 ui->tableView_fix->setRowHeight (row1,100);
    }


ui->tableView_fix->setModel (fixmodel);

                    }

                    Pradeep Kumar
                    Qt,QML Developer

                    1 Reply Last reply
                    1
                    • Pradeep KumarP Offline
                      Pradeep KumarP Offline
                      Pradeep Kumar
                      wrote on last edited by Pradeep Kumar
                      #10

                      As @SGaist said u need to specify Columncount and rowcount.

                      fixmodel->setData (fixmodel->index(row1,5),query_fix.value (10).toString ());

                      fixmodel->setData (fixmodel->index(row1,5),date);

                      Are u trying to insert different values in same column?.

                      Pradeep Kumar
                      Qt,QML Developer

                      1 Reply Last reply
                      3
                      • VRoninV Offline
                        VRoninV Offline
                        VRonin
                        wrote on last edited by VRonin
                        #11

                        EDIT, sorry, this is a duplicate of @SGaist 's answer

                        you are never adding the columns...

                        for(int row1 = 1; query_fix.next (); row1++)
        {
            if(row1 == 0)

                        row1 is never 0

                        "La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
                        ~Napoleon Bonaparte

                        On a crusade to banish setIndexWidget() from the holy land of Qt

                        G 1 Reply Last reply
                        1
                        • VRoninV VRonin

                          EDIT, sorry, this is a duplicate of @SGaist 's answer

                          you are never adding the columns...

                          for(int row1 = 1; query_fix.next (); row1++)
        {
            if(row1 == 0)

                          row1 is never 0

                          G Offline
                          G Offline
                          gabor53
                          wrote on last edited by
                          #12

                          @VRonin
                          Hi,
                          I rewrote a few things. As a result it displays data:

                          void FixDb::correctFriend()
{
    qDebug() << "Entered correctFriend!";

    QSqlQuery query_fix  ("SELECT * FROM Items ORDER BY NAME ASC ");

    if(query_fix.isActive()==true)
        {
            qDebug() << "The query_fix is active.";
        }
    else
        {
            qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
        }

    QStandardItemModel *fixmodel = new QStandardItemModel(this);


    const QSqlRecord qR = query_fix.record ();
    qDebug() << "The number of records: " << qR;
    fixmodel->insertColumns (0, qR.count());

    for(int row1 = 0; query_fix.next (); row1++)
        {
            fixmodel->insertRow (row1);
            fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString ());
            fixmodel->setData (fixmodel->index(row1,1),query_fix.value (1).toString ());
            fixmodel->setData (fixmodel->index(row1,2),query_fix.value (13).toString ());

            qDebug() << "ID in fix: " << query_fix.value (0).toString ();

            fixPixmap.loadFromData (query_fix.value (2).toByteArray ());
            fixPixmap = fixPixmap.scaled (100,100,Qt::KeepAspectRatio);

            fixmodel->setData (fixmodel->index (row1,3),fixPixmap,Qt::DecorationRole);
            fixmodel->setData (fixmodel->index(row1,4),query_fix.value (11).toString ());
            fixmodel->setData (fixmodel->index(row1,5),query_fix.value (10).toString ());
            fixmodel->setData (fixmodel->index(row1,6),query_fix.value (3).toString ());

            monthf = query_fix.value (4).toString ();
            dayf = query_fix.value (5).toString ();
            yearf = query_fix.value (6).toString ();
            date = monthf + "/" + dayf + "/" + yearf;

            fixmodel->setData (fixmodel->index(row1,7),date);
            fixmodel->setData (fixmodel->index(row1,8),query_fix.value (12).toString ());
            fixmodel->setData (fixmodel->index(row1,9),query_fix.value (7).toString ());
            fixmodel->setData (fixmodel->index(row1,10),query_fix.value (8).toString ());
            fixmodel->setData (fixmodel->index(row1,11),query_fix.value (9).toString ());
            ui->tableView_fix->setRowHeight (row1,100);

            ui->tableView_fix->horizontalHeader ()->setStyleSheet ("QHeaderView{font: 14pt Arial; color: blue; font-weight: bold;text-decoration: underline;}");
            ui->tableView_fix->verticalHeader ()->setVisible (false);
            ui->tableView_fix->setAlternatingRowColors (true);
            ui->tableView_fix->setStyleSheet ("alternate-background-color: rgb(224,255,248); background-color: white; font: 14pt Arial");
            ui->tableView_fix->setEditTriggers (QAbstractItemView::CurrentChanged);
            fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));
            fixmodel->setHeaderData (1,Qt::Horizontal, QObject::tr("Name"));
            fixmodel->setHeaderData (2,Qt::Horizontal, QObject::tr("What is the Friend?"));
            fixmodel->setHeaderData (3,Qt::Horizontal, QObject::tr("Picture"));
            fixmodel->setHeaderData (4,Qt::Horizontal, QObject::tr("Material"));
            fixmodel->setHeaderData (5,Qt::Horizontal, QObject::tr("Color"));
            fixmodel->setHeaderData (6,Qt::Horizontal, QObject::tr("Description"));
            fixmodel->setHeaderData (7,Qt::Horizontal, QObject::tr("Adoption Date"));
            fixmodel->setHeaderData (8,Qt::Horizontal, QObject::tr("Signed by"));
            fixmodel->setHeaderData (9,Qt::Horizontal, QObject::tr("History"));
            fixmodel->setHeaderData (10,Qt::Horizontal, QObject::tr("Age"));
            fixmodel->setHeaderData (11,Qt::Horizontal, QObject::tr("Notes"));

            ui->tableView_fix->setColumnWidth (0,1);
            ui->tableView_fix->setColumnWidth (1,200);
            ui->tableView_fix->setColumnWidth (2,200);
            ui->tableView_fix->setColumnWidth (3,90);
            ui->tableView_fix->setColumnWidth (4,200);
            ui->tableView_fix->setColumnWidth (5,200);
            ui->tableView_fix->setColumnWidth (6,350);
            ui->tableView_fix->setColumnWidth (7,200);
            ui->tableView_fix->setColumnWidth (8,200);
            ui->tableView_fix->setColumnWidth (9,350);
            ui->tableView_fix->setColumnWidth (10,200);
            ui->tableView_fix->setColumnWidth (11,350);

            ui->tableView_fix->setWordWrap (true);

            ui->tableView_fix->setModel (fixmodel);
        }
}

                          The only problems I found:
                          1.) The first row's height is much less than the rest of the rows.
                          2.) The ID column is completely missing.
                          Is this the model's issue or i cut the first column off somewhere?
                          Thank you for all your help.

                          1 Reply Last reply
                          0
                          • VRoninV Offline
                            VRoninV Offline
                            VRonin
                            wrote on last edited by VRonin
                            #13

                            fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString ());

                            don't call toString, setdata wants a QVariant, no need to convert anything

                            The problems you mentioned look a lot like view issues rather than model issues? are you using a custom view or delegate?

                            this

                            monthf = query_fix.value (4).toString ();
            dayf = query_fix.value (5).toString ();
            yearf = query_fix.value (6).toString ();
            date = monthf + "/" + dayf + "/" + yearf;
fixmodel->setData (fixmodel->index(row1,7),date);

                            is bad on so many levels.

                            use

                            fixmodel->setData (fixmodel->index(row1,7),QDate(query_fix.value (6).toInt(),query_fix.value (4).toInt(),query_fix.value (5).toInt());

                            "La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
                            ~Napoleon Bonaparte

                            On a crusade to banish setIndexWidget() from the holy land of Qt

                            G 2 Replies Last reply
                            0
                            • VRoninV VRonin

                              fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString ());

                              don't call toString, setdata wants a QVariant, no need to convert anything

                              The problems you mentioned look a lot like view issues rather than model issues? are you using a custom view or delegate?

                              this

                              monthf = query_fix.value (4).toString ();
            dayf = query_fix.value (5).toString ();
            yearf = query_fix.value (6).toString ();
            date = monthf + "/" + dayf + "/" + yearf;
fixmodel->setData (fixmodel->index(row1,7),date);

                              is bad on so many levels.

                              use

                              fixmodel->setData (fixmodel->index(row1,7),QDate(query_fix.value (6).toInt(),query_fix.value (4).toInt(),query_fix.value (5).toInt());
                              G Offline
                              G Offline
                              gabor53
                              wrote on last edited by
                              #14

                              @VRonin said in QStandardItemModel doesn't display data:

                              fixmodel->setData (fixmodel->index(row1,7),QDate(query_fix.value (6).toInt(),query_fix.value (4).toInt(),query_fix.value (5).toInt());

                              I did the changes you recommended. The change is that in the Name column in the first row I have the ID. If I click on anywhere on the table, the ID from the first row disappears, replaced by the Name and the ID columns is still completely missing.

                              1 Reply Last reply
                              0
                              • VRoninV VRonin

                                fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0).toString ());

                                don't call toString, setdata wants a QVariant, no need to convert anything

                                The problems you mentioned look a lot like view issues rather than model issues? are you using a custom view or delegate?

                                this

                                monthf = query_fix.value (4).toString ();
            dayf = query_fix.value (5).toString ();
            yearf = query_fix.value (6).toString ();
            date = monthf + "/" + dayf + "/" + yearf;
fixmodel->setData (fixmodel->index(row1,7),date);

                                is bad on so many levels.

                                use

                                fixmodel->setData (fixmodel->index(row1,7),QDate(query_fix.value (6).toInt(),query_fix.value (4).toInt(),query_fix.value (5).toInt());
                                G Offline
                                G Offline
                                gabor53
                                wrote on last edited by
                                #15

                                @VRonin
                                As it looks It displays the database from column 2.

                                1 Reply Last reply
                                0
                                • VRoninV Offline
                                  VRoninV Offline
                                  VRonin
                                  wrote on last edited by VRonin
                                  #16

                                  do you have any events linked to selection or click?

                                  "La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
                                  ~Napoleon Bonaparte

                                  On a crusade to banish setIndexWidget() from the holy land of Qt

                                  G 2 Replies Last reply
                                  0
                                  • VRoninV VRonin

                                    do you have any events linked to selection or click?

                                    G Offline
                                    G Offline
                                    gabor53
                                    wrote on last edited by
                                    #17

                                    @VRonin

                                    No. Or at least not yet.

                                    1 Reply Last reply
                                    0
                                    • VRoninV VRonin

                                      do you have any events linked to selection or click?

                                      G Offline
                                      G Offline
                                      gabor53
                                      wrote on last edited by
                                      #18

                                      @VRonin
                                      The following code displays the ID column:

                                      void FixDb::correctFriend()
{
    qDebug() << "Entered correctFriend!";

    QSqlQuery query_fix  ("SELECT ID FROM Items ORDER BY NAME ASC ");

    if(query_fix.isActive()==true)
        {
            qDebug() << "The query_fix is active.";
        }
    else
        {
            qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
        }

    while(query_fix.next ())
        {
            QString tempID = query_fix.value (0).toString ();
            qDebug() << "TempID: " << tempID;
        }

    QStandardItemModel *fixmodel = new QStandardItemModel(this);
    ui->tableView_fix->setModel (fixmodel);

    const QSqlRecord qR = query_fix.record ();
    qDebug() << "The number of records: " << qR;
    fixmodel->insertColumns (0,qR.count ());

    for(int row1 = 0; query_fix.next (); row1++)
        {
            fixmodel->insertRow (row1);
        }

    ui->tableView_fix->horizontalHeader ()->setStyleSheet ("QHeaderView{font: 14pt Arial; color: blue; font-weight: bold;text-decoration: underline;}");
    ui->tableView_fix->setAlternatingRowColors (true);
    ui->tableView_fix->setStyleSheet ("alternate-background-color: rgb(224,255,248); background-color: white; font: 14pt Arial");

    fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));

    ui->tableView_fix->setColumnWidth (0,100);
}

                                      but when I add

                                       fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0));

                                      after insertRow the column header disappears and the tableview is empty.

                                      1 Reply Last reply
                                      0
                                      • VRoninV Offline
                                        VRoninV Offline
                                        VRonin
                                        wrote on last edited by VRonin
                                        #19

                                        I have a strong suspect the problem lies in the view, could you try the code below and see if the column is displayed correctly?

                                        void FixDb::correctFriend()
{
    qDebug() << "Entered correctFriend!";

    QSqlQuery query_fix  ("SELECT ID FROM Items ORDER BY NAME ASC ");

    if(query_fix.isActive()==true)
        {
            qDebug() << "The query_fix is active.";
        }
    else
        {
            qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
        }

    while(query_fix.next ())
        {
            QString tempID = query_fix.value (0).toString ();
            qDebug() << "TempID: " << tempID;
        }

    QStandardItemModel *fixmodel = new QStandardItemModel(this);
QTableView* tempView=new QTableView;
tempView->setAttribute( Qt::WA_DeleteOnClose ); // To prevent memory leak
    tempView->setModel (fixmodel);

    const QSqlRecord qR = query_fix.record ();
    qDebug() << "The number of records: " << qR;
    fixmodel->insertColumns (0,qR.count ());

    for(int row1 = 0; query_fix.next (); row1++)
        {
            fixmodel->insertRow (row1);
fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0));
        }

   

    fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));

    tempView->show();
}

                                        "La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
                                        ~Napoleon Bonaparte

                                        On a crusade to banish setIndexWidget() from the holy land of Qt

                                        G 2 Replies Last reply
                                        3
                                        • VRoninV VRonin

                                          I have a strong suspect the problem lies in the view, could you try the code below and see if the column is displayed correctly?

                                          void FixDb::correctFriend()
{
    qDebug() << "Entered correctFriend!";

    QSqlQuery query_fix  ("SELECT ID FROM Items ORDER BY NAME ASC ");

    if(query_fix.isActive()==true)
        {
            qDebug() << "The query_fix is active.";
        }
    else
        {
            qDebug() << "The query_fix is NOT active." << query_fix.lastError ();
        }

    while(query_fix.next ())
        {
            QString tempID = query_fix.value (0).toString ();
            qDebug() << "TempID: " << tempID;
        }

    QStandardItemModel *fixmodel = new QStandardItemModel(this);
QTableView* tempView=new QTableView;
tempView->setAttribute( Qt::WA_DeleteOnClose ); // To prevent memory leak
    tempView->setModel (fixmodel);

    const QSqlRecord qR = query_fix.record ();
    qDebug() << "The number of records: " << qR;
    fixmodel->insertColumns (0,qR.count ());

    for(int row1 = 0; query_fix.next (); row1++)
        {
            fixmodel->insertRow (row1);
fixmodel->setData (fixmodel->index(row1,0),query_fix.value (0));
        }

   

    fixmodel->setHeaderData (0,Qt::Horizontal, QObject::tr("ID"));

    tempView->show();
}
                                          G Offline
                                          G Offline
                                          gabor53
                                          wrote on last edited by
                                          #20

                                          @VRonin
                                          It displays only the original tableview from the ui. I can't see tempView .

                                          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