Results 1 to 12 of 12

Thread: [QSqlQuery] Problem with not open database

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 23rd July 2010, 02:18 #7
    spiderman3000p
    spiderman3000p is offline Beginner
    Join Date
    Jul 2010
    Posts
    7
    Qt products
    Qt4
    Platforms
    Windows

    Question Re: [QSqlQuery] Problem with not open database

    i have the same problem.
    im using a SQLITE3 database. i didnt create the table contained from my app, i've crate it outside with another program (sqlite browser).


    here is the first fragment of my code, below:
    Qt Code: 
    1. #include "mainwindow.h"
    2. #include "ui_mainwindow.h"
    3.  #include <QSqlDriver>
    4. #include <QSqlDatabase>
    5. #include <QSqlQuery>
    6. #include <QSqlQueryModel>
    7. #include <QSqlTableModel>
    8. #include <QMessageBox>
    9. #include <QSqlError>
    10. #include <QDate>
    11. QString movistar[6]={"10 Bs","12 Bs","20 Bs","25 Bs","40 Bs","60 Bs"};
    12. QString movilnet[4]={"15 Bs","25 Bs","40 Bs","60 Bs"};
    14. int mov=6,movi=4;
    15.  
    16. MainWindow::MainWindow(QWidget *parent) :
    17.     QMainWindow(parent),
    18.     ui(new Ui::MainWindow)
    19. {
    20.     ui->setupUi(this);
    21.     //deshabilitar boton maximizar
    22.    // this->setWindowFlags(Qt::WindowMinimizeButtonHint);
    23.    //create the database
    24.     QSqlDatabase bd=QSqlDatabase::addDatabase("QSQLITE");
    25.     //set database name
    26.     bd.setDatabaseName("C:/registro de ventas.db3");
    27.   bd.setPassword("120590");
    28.    bd.setHostName("localhost");
    29.  
    30.     if(!bd.open())
    31.     {
    32.        MessageBox::critical(this,"error","error al abrir base de datos");
    33.  
    34.  
    35.     }
    36.    else
    37.    { MessageBox::about(this,"error","base de datos abierta");
    38.  
    39.    }
    40.    //inicializando montos....
    41.     for(int i=0;i<6;i++)
    42.    ui->monto->addItem(movistar[i]);
    43.  
    44.    ui->monto->setCurrentIndex(0);
    45.  
    46.    calcular();
    47.    //-------------------
    48. }
    To copy to clipboard, switch view to plain text mode 

    in this first segment of the code, i can realize that the conection to the database its succesfuly done.
    the problem come when i try to execute any query...insert, for example.

    Qt Code: 
    1. void MainWindow::vender()
    3.  venta objeto;
    4.  
    5.    int indice=ui->monto->currentIndex();
    6.    int tarjeta=0;
    7.    int cant=ui->cantidad->value();
    8.    float recibido=ui->efectivo->text().toFloat();
    9.    objeto.cantidad=cant;
    10.    if(ui->tipo->currentText()=="Movistar")
    11.    { switch(indice)
    12.      {
    13.      case 0: tarjeta=10;break;
    14.      case 1: tarjeta=12;break;
    15.      case 2: tarjeta=20;break;
    16.      case 3: tarjeta=25;break;
    17.      case 4: tarjeta=40;break;
    18.      case 5: tarjeta=60;break;
    19.      }
    20.    }
    21.    if(ui->tipo->currentText()=="Movilnet")
    22.    { switch(indice)
    23.      {
    24.      case 0: tarjeta=15;break;
    25.      case 1: tarjeta=25;break;
    26.      case 2: tarjeta=40;break;
    27.      case 3: tarjeta=60;break;
    28.      }
    29.    }
    30.   //calculando monto a cobrar, vuelto
    31.   float acobrar=cant*tarjeta;
    32.  
    33.   float vuelto2=recibido-(acobrar);
    34.  
    35.   objeto.tipo=ui->tipo->currentText();
    36.    //hora
    37.   QDate d;
    38.   QTime t;
    39.   QString message;
    40.   objeto.hora=t.currentTime();
    41.   objeto.fecha=d.currentDate();
    42.    //fecha
    43.    objeto.acobrar=acobrar;
    44.    objeto.recibido=recibido;
    45.    objeto.vuelto=vuelto2;
    46.  
    47.  if(registrar_BD(objeto))      //<------------------------------------------ here i call the function that will execute the query
    48.  {m.setText("Registro exitoso");}
    49.  else
    50.  {message=sql.lastError().Text(); //< ---------------------- this will show me if any error happend.
    51.      m.setText(message);
    52.  
    53.  }
    54.  
    55.  m.exec();
    56.  
    57. }
    58.  
    59. bool MainWindow::registrar_BD(venta objeto)//<---- this its the object that contain the data that i want to save
    60. {  // and her i asingn constants values just for try
    61.    return (sql.exec("INSERT INTO venta(tarjeta,monto,cantidad,efectivo_recibido,efectivo_devuelto) VALUES('digitel',20,1,40,20)"));
    62.  
    63.  //return (sql.exec("insert into ventas (fecha,hora,tarjeta,monto,cantidad,efectivo_recibido,efectivo_devuelto)
    64. //"values(objeto.fecha,objeto.hora,objeto.tipo,objeto.monto,objeto.cantidad,objeto.recibido,objeto.vuelto)"));
    65.  
    66.  
    67. }
    To copy to clipboard, switch view to plain text mode 

    and this is the code of thel mainwindow.h:
    Qt Code: 
    1. #ifndef MAINWINDOW_H
    2. #define MAINWINDOW_H
    3.  
    4. #include <QMainWindow>
    5. #include<mis_datos.h>
    6. #include <QSqlQuery>
    7. namespace Ui {
    8.     class MainWindow;
    9. }
    10.  
    11. class MainWindow : public QMainWindow
    12. {
    13.     Q_OBJECT
    14.  
    15. public:
    16.     explicit MainWindow(QWidget *parent = 0);
    17.     ~MainWindow();
    18.  
    19. private:
    20.     Ui::MainWindow *ui;
    21.     QImage Imagen;
    22. private slots:
    23. void calcular();
    24. void comprobarTipo();
    25. void mostrarimg();
    26. void cargarimg(int,int);
    27. void vender();
    28. bool registrar_BD(venta);
    29. };
    30.  
    31. #endif // MAINWINDOW_H
    To copy to clipboard, switch view to plain text mode 

    when i execute my app, just when i push the "vender" button, this is what i got:

    i have to say that i've tried to compile the libraries of sqlite with the commands below:
    configure -qt-sql-sqlite para habilitar las librerias sqlite
    and configure -qmake32 ...or something like that...

    i've tried:
    put my app in the directory: Qt/2010.04/qt/bin
    copy and pste the dll's of sqlite from Qt/2010.04/qt/bin and sqldrivers to my app directory
    here is a rar whith the proyect (i know that it have so many sintaxis errors and logicals errors, but it doesnt matter in the end):
    http://www.fileden.com/files/2007/6/..._tarjetas2.rar

    some details

    * the file "registro de ventas.db3" that its inside the rar, is the database that must be in C partition. well, in my code i put it there, you can move it for use it. but that is the file that have to be used.

    * my qt version is 4.6.3. con qt creator 2.0

    i hope some one of u give me the answer!!!!! the succesfull answer!

    thanks so much friends!
    Last edited by spiderman3000p; 23rd July 2010 at 04:02. Reason: updated contents
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Qt is a trademark of The Qt Company.