Results 1 to 3 of 3

Thread: QSqlite problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 21st March 2007, 17:05 #1
    dragon
    dragon is offline Intermediate user
    Join Date
    Jan 2006
    Posts
    115
    Thanked 1 Time in 1 Post
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default QSqlite problem

    Hello anyone,

    I using Qt-4.2.3 on Windows XP
    I have made a database called freesdb and insert the records through a dialog and works fine.
    The problem is i can insert into the database up to 256 records and then in the same direktory where the freesdb is staying a another database pops up called freesdb-journal.
    These freesdb-journal is blockking further inserting records in my freesdb.
    I read over the net there no limitation of records in Sqlite database.

    How is possible to get more records in my freesdb. ( more then 256 records).

    Here my code for the connection for my database.
    connection.h
    Qt Code: 
    1. #ifndef CONNECTION_H
    2. #define CONNECTION_H
    3.  
    4. #include <QMessageBox>
    5. #include <QSqlDatabase>
    6. #include <QSqlError>
    7. #include <QSqlQuery>
    8.  
    9.  
    10. static bool createConnection()
    11. {
    12.     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    13.     db.setDatabaseName("frezen");
    14.     db.setHostName("localhost");
    15.     db.setUserName("jan");
    16.     db.setPassword("asdfgh");
    17.     if (!db.open()) {
    18.         QMessageBox::warning(0, ("Cannot open database"),
    19.             ("Unable to establish a database connection.\n") + db.lastError().text());
    20.         return false;
    21.     }
    22. 	QSqlQuery query;
    23.     query.exec("create table frezen (materiaal varchar(20), treksterkte varchar(20),"
    24. "freestype varchar(20), freesdiameter varchar(20), aantaltanden varchar(20),"
    25. "koeling varchar(10), freesbewerking varchar(20), snijsnelheid varchar(20),"
    26. "voedingpertand varchar(20), snedediepte varchar(10), snedebreedte varchar(10))");   
    27.  
    28.     return true;
    29. }
    30.  
    31. #endif
    To copy to clipboard, switch view to plain text mode 

    Here my code for inserting records
    frezen.cpp
    Qt Code: 
    1. #include <QtGui>
    2. #include <QtSql>
    3. #include <QSqlError>
    4. #include <QSqlRecord>
    5.  
    6. #include "frezen.h"
    7. #include "frees.h"
    8.  
    9.  
    10. Frezen::Frezen(const QString &frezen, QWidget *parent)
    11.     : QDialog(parent)
    12. {
    13.     model = new QSqlTableModel(this);
    14.     model->setTable(frezen);
    15.     model->setSort(1, Qt::DescendingOrder);
    16.     model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    17.     model->select();
    18.  
    19. 	model->setHeaderData(0, Qt::Horizontal, tr("Materiaal"));
    20. 	model->setHeaderData(1, Qt::Horizontal, tr("Treksterkte"));
    21. 	model->setHeaderData(2, Qt::Horizontal, tr("Frees type"));
    22. 	model->setHeaderData(3, Qt::Horizontal, tr("Frees diameter"));
    23. 	model->setHeaderData(4, Qt::Horizontal, tr("Aantal tanden"));
    24. 	model->setHeaderData(5, Qt::Horizontal, tr("Koeling"));
    25. 	model->setHeaderData(6, Qt::Horizontal, tr("Frees bewerking"));
    26. 	model->setHeaderData(7, Qt::Horizontal, tr("Snijsnelheid"));
    27. 	model->setHeaderData(8, Qt::Horizontal, tr("Voeding per tand"));
    28. 	model->setHeaderData(9, Qt::Horizontal, tr("Snedediepte"));
    29. 	model->setHeaderData(10, Qt::Horizontal, tr("Snedebreedte"));
    30.  
    31.  
    32.  
    33.     QTableView *view = new QTableView;
    34.     view->setModel(model);
    35.  
    36.  
    37.     addButton = new QPushButton("Toevoegen");
    38.     removeButton = new QPushButton(" Verwijderen");
    39.     submitButton = new QPushButton(tr("Submit"));
    40.     submitButton->setDefault(true);
    41.     quitButton = new QPushButton("Afsluiten");
    42.  
    43.     connect(submitButton, SIGNAL(clicked()), this, SLOT(submit()));
    44.     connect(quitButton, SIGNAL(clicked()), this, SLOT(close()));
    45.     connect(addButton, SIGNAL(clicked()), this, SLOT(setData()));
    46.     connect(removeButton, SIGNAL(clicked()), this, SLOT(deleteRow()));
    47.  
    48.  
    49.     QVBoxLayout *buttonLayout = new QVBoxLayout;
    50.     buttonLayout->addWidget(addButton);
    51.     buttonLayout->addWidget(removeButton);
    52.     buttonLayout->addWidget(submitButton);
    53.     buttonLayout->addStretch(1);
    54.     buttonLayout->addWidget(quitButton);
    55.  
    56.     QHBoxLayout *mainLayout = new QHBoxLayout;
    57.     mainLayout->addWidget(view);
    58.     mainLayout->addLayout(buttonLayout);
    59.     setLayout(mainLayout);
    60.  
    61.     setWindowTitle(tr("Frezen"));
    62.     resize (400, 400);
    63. }
    64.  
    65. void Frezen::submit()
    66. {
    67.    model->database().transaction();
    68.     if (model->submitAll()) {
    69.         model->database().commit();
    70.     } else {
    71.         model->database().rollback();
    72.         QMessageBox::warning(this, tr("frezen"),
    73.                              tr("The database reported an error: %1")
    74.                              .arg(model->lastError().text()));
    75.     }
    76. }
    77.  
    78.  
    79.  
    80. void Frezen::setData()
    81.  
    82. {
    83. 	freesDialog dlg(this);
    84. 	if( dlg.exec() == QDialog::Accepted )   {
    85.  
    86.         QString materiaal = dlg.matComboBox->currentText();
    87. 	QString treksterkte = dlg.trekComboBox->currentText();
    88. 	QString freestype = dlg.freesComboBox->currentText();
    89. 	QString freesdiameter = dlg.diaComboBox->currentText();
    90. 	QString aantaltanden= dlg.tandComboBox->currentText();
    91. 	QString koeling = dlg.koelComboBox->currentText();
    92. 	QString freesbewerking = dlg.freesbComboBox->currentText();
    93. 	QString snijsnelheid = dlg.snijComboBox->currentText();
    94. 	QString voedingpertand = dlg.voedingComboBox->currentText();
    95. 	QString snedediepte = dlg.snedeComboBox->currentText();
    96. 	QString snedebreedte = dlg.snedebComboBox->currentText();
    97.  
    98.  
    99.  
    100.  
    101. 	model->insertRows(0, 1);
    102.         model->setData(model->index(0, 0), materiaal);
    103.         model->setData(model->index(0, 1), treksterkte);
    104.         model->setData(model->index(0, 2), freestype);
    105.         model->setData(model->index(0, 3), freesdiameter);
    106.         model->setData(model->index(0, 4), aantaltanden);
    107.         model->setData(model->index(0, 5), koeling);
    108.         model->setData(model->index(0, 6), freesbewerking);
    109.         model->setData(model->index(0, 7), snijsnelheid);
    110.         model->setData(model->index(0, 8), voedingpertand);
    111.         model->setData(model->index(0, 9), snedediepte);
    112.         model->setData(model->index(0, 10), snedebreedte);
    113.  
    114.         return;
    115.         }
    116.  
    117. }
    118.  
    119. void Frezen::deleteRow()
    120. {
    121.  
    122.  
    123. }
    To copy to clipboard, switch view to plain text mode 

    Thanks in advance
    Last edited by jacek; 21st March 2007 at 23:52. Reason: wrapped too long line
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. QTimer problem ... it runs but never triggs
    By yellowmat in forum Newbie
    Replies: 4
    Last Post: 4th July 2006, 12:54
  2. Grid Layout Problem
    By Seema Rao in forum Qt Programming
    Replies: 2
    Last Post: 4th May 2006, 12:45
  3. Problem with bitBlt
    By yellowmat in forum Newbie
    Replies: 1
    Last Post: 5th April 2006, 14:08
  4. fftw problem
    By lordy in forum General Programming
    Replies: 1
    Last Post: 16th March 2006, 21:36
  5. Architecture problem using threads, custom events and signals/slots
    By yellowmat in forum Newbie
    Replies: 16
    Last Post: 7th March 2006, 15:57

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

Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.