Need help on QSQLITE

[lam-ang]

Hi, I still have errors and would not compile..

:-1: warning: The Symbian tool chain does not handle special characters in the project name 'SQLite_example.pro' well.

:-1: warning: The Symbian tool chain does not handle special characters in the project name 'SQLite_example.pro' well.

To copy to clipboard, switch view to plain text mode 

I noticed if I remove this part of code ".arg(database.lasteError().text())" it compiles.

regards,
lam-ang

[mcosta]

The correct code is

if(!database->open())  {
    QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1").arg(database->lastError().text()));
}

if(!database->open())  {
    QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1").arg(database->lastError().text()));
}

To copy to clipboard, switch view to plain text mode 

try it please

[lam-ang]

Hi, I tried it and unfortunately it does nos compile...

#include "phonebook.h"
#include "ui_phonebook.h"
#include <QMessageBox>
#include <QDesktopservices.h>
//./phonebook.db
PhoneBook::PhoneBook(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::PhoneBook)
{
    ui->setupUi(this);
 
    database = new QSqlDatabase();
 
    //set database driver to QSQLITE
    *database = QSqlDatabase::addDatabase("QSQLITE");
   // database->setDatabaseName(":memory:");
    //database->setDatabaseName("./phonebook.db");
    QString dbName = QDesktopServices::storageLocation (QDesktopServices::DataLocation) + "/phonebook.db";
    database->setDatabaseName(dbName);
 
    //can be removed
    //database->setHostName("localhost");
    //database->setUserName("");
    //database->setPassword("");
 
    if(!database->open())  {
        QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1").arg(database->lastError().text()));
    }
 
     QSqlQuery query;
     query.exec("CREATE TABLE IF NOT EXISTS Contacts (id int primary key, "
                "name varchar(20), mobile varchar(20),city varchar(20))");
    all_model = new QSqlTableModel(this, *database);
    updateTable();
 
    search_model = new QSqlTableModel(this, *database);
    search_model->setTable("Contacts");
}

#include "phonebook.h"
#include "ui_phonebook.h"
#include <QMessageBox>
#include <QDesktopservices.h>
//./phonebook.db
PhoneBook::PhoneBook(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::PhoneBook)
{
    ui->setupUi(this);

    database = new QSqlDatabase();

    //set database driver to QSQLITE
    *database = QSqlDatabase::addDatabase("QSQLITE");
   // database->setDatabaseName(":memory:");
    //database->setDatabaseName("./phonebook.db");
    QString dbName = QDesktopServices::storageLocation (QDesktopServices::DataLocation) + "/phonebook.db";
    database->setDatabaseName(dbName);

    //can be removed
    //database->setHostName("localhost");
    //database->setUserName("");
    //database->setPassword("");

    if(!database->open())  {
        QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1").arg(database->lastError().text()));
    }

     QSqlQuery query;
     query.exec("CREATE TABLE IF NOT EXISTS Contacts (id int primary key, "
                "name varchar(20), mobile varchar(20),city varchar(20))");
    all_model = new QSqlTableModel(this, *database);
    updateTable();

    search_model = new QSqlTableModel(this, *database);
    search_model->setTable("Contacts");
}

To copy to clipboard, switch view to plain text mode 

But if I comment this line like this..

if(!database->open())  {
        QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1"));//.arg(database->lastError().text()));
    }

if(!database->open())  {
        QMessageBox::warning(0,"Error",tr("Couldn't open database file: %1"));//.arg(database->lastError().text()));
    }

To copy to clipboard, switch view to plain text mode 

and here is the result when compiled...

Executable file: 15482 2011-06-13T15:12:58 C:\QtSDK\Symbian\SDKs\Symbian1Qt473\\epoc32\release\gcce\urel\SQLite_example.exe
Starting application...
Application running with pid 4355.
[Qt Message] QSqlQuery::exec: database not open

Executable file: 15482 2011-06-13T15:12:58 C:\QtSDK\Symbian\SDKs\Symbian1Qt473\\epoc32\release\gcce\urel\SQLite_example.exe
Starting application...
Application running with pid 4355.
[Qt Message] QSqlQuery::exec: database not open

To copy to clipboard, switch view to plain text mode 

thanks,
lam-ang

[mcosta]

Hi, I tried it and unfortunately it does nos compile...

What is the error?
Probably you have to add some include in your source. Perhaps

#include <QtSql/QSqlError>

#include <QtSql/QSqlError>

To copy to clipboard, switch view to plain text mode 

[vishnu]

Hi

It seems you can run execute your application successfully. But DB is empty/volatile if you restart your qt application. am I right?

if yes,

Try this

Qt Code:

database->setDatabaseName("memory.db");

and use CREATE TABLE command rather than CREATE TABLE IF NOT EXISTS Contacts.

Thanks,
Vishnu

[lam-ang]

Hello there,
Thanks for helping me out, I appreciate it very much...its running fine now.
I hope it is okay if I have another question, how can I use another database like Mysql if my target is a pc..any idea or link?

thanks and regards,
lam-ang

[vishnu]

Hello,

IF you want to know about the SQL support drivers,

use the following debug code,

debugLog("Driver supports name "<<db.drivers());

debugLog("Driver supports name "<<db.drivers());

To copy to clipboard, switch view to plain text mode 

you can get the list supporting drivers name.

I think PC will support the following the drivers ("QSQLITE", "QPSQL7", "QPSQL") by default