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. QSqlQuery different value() type
Forum Updated to NodeBB v4.3 + New Features

QSqlQuery different value() type

Scheduled Pinned Locked Moved Unsolved General and Desktop
qsqlquerymysqlqvariant5.6.0
13 Posts 2 Posters 4.5k 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.
  • XardasX Offline
    XardasX Offline
    Xardas
    wrote on last edited by
    #4

    Checked again, on 5_5_1 has no problem.
    first table: QVariant(uint, 1);
    second table: QVariant(uint, 1);

    any ideas, what is the problem?

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

      One unrelated note, you're not using QSqlDatabase correctly. There's no need to use new on it.

      What OS and MySQL version are you using ?

      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
      1
      • XardasX Offline
        XardasX Offline
        Xardas
        wrote on last edited by
        #6

        OS: Windows 10
        Mysql: 5.7.11

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

          Did you only change Qt version or also MySQL ?

          Did you rebuild the MySQL plugin ?

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

          XardasX 1 Reply Last reply
          0
          • SGaistS SGaist

            Did you only change Qt version or also MySQL ?

            Did you rebuild the MySQL plugin ?

            XardasX Offline
            XardasX Offline
            Xardas
            wrote on last edited by
            #8

            @SGaist said:

            Did you only change Qt version or also MySQL ?

            only Qt version

            @SGaist said:

            Did you rebuild the MySQL plugin ?

            Yes

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

              What size are both tables ?

              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
              0
              • XardasX Offline
                XardasX Offline
                Xardas
                wrote on last edited by
                #10

                first: 16KiB
                second: 16KiB

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

                  I meant number of rows of each tables.

                  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
                  0
                  • XardasX Offline
                    XardasX Offline
                    Xardas
                    wrote on last edited by
                    #12

                    first table 129
                    second 3

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

                      The plugin hasn't changed anything related to that between 5.5 and 5.6 so I wonder if it's a change in QVariant.

                      By the way, why do you need that information ? You should be able to just convert to int without any problem.

                      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
                      0

                      • Login

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