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

QSqlQuery different value() type

Scheduled Pinned Locked Moved Unsolved General and Desktop
qsqlquerymysqlqvariant5.6.0
13 Posts 2 Posters 5.3k 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