Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. International
  3. Spanish
  4. QSqlQuery.next() no se esta ejecutando ...
Forum Updated to NodeBB v4.3 + New Features

QSqlQuery.next() no se esta ejecutando ...

Scheduled Pinned Locked Moved Solved Spanish
5 Posts 4 Posters 610 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.
  • U Offline
    U Offline
    U7Development
    wrote on last edited by
    #1

    Hola !.

    Tengo este código:

    int main(int argc, char *argv[]){
        QCoreApplication a(argc, argv);
    
        QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setDatabaseName("Driver={MySQL ODBC 8.0 Unicode Driver};"
                           "Server=192.168.1.200,3306;"
                           "Database=db0;"
                           "Uid=root;"
                           "Pwd=$$Mas7eR;"
                           "MULTI_HOST=1;");
    
        if (!db.open()) qDebug() << db.lastError().text();
        else {
            QSqlQuery consulta;
            consulta.prepare("select * from tcentros;");
    
            //Lo siguiente no se esta ejecutando, es decir, consulta.next() es false
            while (consulta.next()).    qDebug() << "A";
            
            db.close();
        }
        return a.exec();
    }
    

    No entiendo por que no se ejecuta,... estoy usando QODBC en vez de QMySQL porque no logré compilar el plugin.... no se si sera eso...

    Alguna idea?
    Gracias de antemano!.

    JonBJ 1 Reply Last reply
    0
    • U U7Development

      Hola !.

      Tengo este código:

      int main(int argc, char *argv[]){
          QCoreApplication a(argc, argv);
      
          QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
          db.setDatabaseName("Driver={MySQL ODBC 8.0 Unicode Driver};"
                             "Server=192.168.1.200,3306;"
                             "Database=db0;"
                             "Uid=root;"
                             "Pwd=$$Mas7eR;"
                             "MULTI_HOST=1;");
      
          if (!db.open()) qDebug() << db.lastError().text();
          else {
              QSqlQuery consulta;
              consulta.prepare("select * from tcentros;");
      
              //Lo siguiente no se esta ejecutando, es decir, consulta.next() es false
              while (consulta.next()).    qDebug() << "A";
              
              db.close();
          }
          return a.exec();
      }
      

      No entiendo por que no se ejecuta,... estoy usando QODBC en vez de QMySQL porque no logré compilar el plugin.... no se si sera eso...

      Alguna idea?
      Gracias de antemano!.

      JonBJ Offline
      JonBJ Offline
      JonB
      wrote on last edited by
      #2

      @U7Development

      if (!consulta.prepare("select * from tcentros;"))
          qDebug() << consulta.lastError();
      

      ?

      U 1 Reply Last reply
      2
      • O Offline
        O Offline
        ollarch
        wrote on last edited by
        #3

        Hola,

        Despues del "prepare" hay que ejecutar al consulta con "exec".

        1 Reply Last reply
        4
        • JonBJ JonB

          @U7Development

          if (!consulta.prepare("select * from tcentros;"))
              qDebug() << consulta.lastError();
          

          ?

          U Offline
          U Offline
          U7Development
          wrote on last edited by
          #4

          @JonB es true....

          @ollarch efectivamente me falto exec()..

          Gracias saludos!

          aha_1980A 1 Reply Last reply
          2
          • U U7Development

            @JonB es true....

            @ollarch efectivamente me falto exec()..

            Gracias saludos!

            aha_1980A Offline
            aha_1980A Offline
            aha_1980
            Lifetime Qt Champion
            wrote on last edited by
            #5

            Hola @U7Development,

            me alegro de que funcione ahora.

            entonces marque este tema como resuelto

            Saludos

            Qt has to stay free or it will die.

            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