Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. International
  3. Italian
  4. Query report
Forum Updated to NodeBB v4.3 + New Features

Query report

Scheduled Pinned Locked Moved Solved Italian
4 Posts 2 Posters 787 Views
  • 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.
  • PollyP Offline
    PollyP Offline
    Polly
    wrote on last edited by
    #1

    Buongiorno avrei bisogno di un'informazione, io ho lanciato una query con un oggetto QsqlDatabase con la funzione exec(). Vorrei sapere con questa classe posso ottenere l'esito della Query in qualche modo o devo usare la classe QsqlQuery

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

      Ti basta salvare il valore che viene ritornato da QSqlDatabase::exec() https://doc.qt.io/qt-5/qsqldatabase.html#exec

      "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

      1 Reply Last reply
      0
      • PollyP Offline
        PollyP Offline
        Polly
        wrote on last edited by
        #3

        Ciao ho provato a leggere la documentazione ma l'oggetto Query che mi restituisce come lo posso tradurre in una stringa?
        Non riesco a capire esattamente come è strutturata la QsqlQuery

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

          da https://doc.qt.io/qt-5/qsqlquery.html

          while (query.next()) { //cicla tutte le righe del risultato
                  qDebug() << query.value(0).toString(); //stampa il contenuto della colonna 0 come stringa
              }
          

          "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

          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