[QT4][SQLITE] Database and query

[munna]

I begin to think that there is a problem with QSqlite but I think that it's an integrated db with Qt, isn't it ?

Yes it is.

Do I have to install some specific programs ?

No you don't have to.

what is databaseFile->filePath()?

QSqlQuery query = new QSqlQuery(db);//This line should give error

QSqlQuery query = new QSqlQuery(db);//This line should give error

To copy to clipboard, switch view to plain text mode 

[agent007se]

what is databaseFile->filePath()?

Isn't enough to know that the connect() function return a true value ?

Anyway here's the code you asked:

in CDatabase.h:

private:
QFileInfo *databaseFile;

private:
QFileInfo *databaseFile;

To copy to clipboard, switch view to plain text mode 

in CDatabase.cpp:

// constructor
CDatabase::CDatabase(QString dbName)
{
    databaseFile = new QFileInfo(dbName);
    CDatabase::dbName = databaseFile->fileName();
}

// constructor
CDatabase::CDatabase(QString dbName)
{
    databaseFile = new QFileInfo(dbName);
    CDatabase::dbName = databaseFile->fileName();
}

To copy to clipboard, switch view to plain text mode 

in SomeFile.cpp:

static CDatabase *CDB;
...
// instantiation of CDB where stest is the return of a QFileDialog::getExistingDirectory (and is not a null string)
CDB = new CDatabase(stest + "/" + dbNameStr + ".db");

static CDatabase *CDB;
...
// instantiation of CDB where stest is the return of a QFileDialog::getExistingDirectory (and is not a null string)
CDB = new CDatabase(stest + "/" + dbNameStr + ".db");

To copy to clipboard, switch view to plain text mode 

QSqlQuery query = new QSqlQuery(db);//This line should give error

QSqlQuery query = new QSqlQuery(db);//This line should give error

To copy to clipboard, switch view to plain text mode 

Just see in the public functions in QSqlQuery :

QSqlQuery ( QSqlDatabase db )

Like I said, the compilation is nice ;-). I don't understand why there might be an error...

I use : Qt 4.1, Windows (mingw) and Code::Blocks...

[aMan]

try to append a semicolon (" ; ") to the sqlstring:

QString createQuery = "CREATE TABLE test;";

QString createQuery = "CREATE TABLE test;";

To copy to clipboard, switch view to plain text mode 

and if that doesn't help, try to get the error:
http://doc.trolltech.com/4.1/qsqlquery.html#lastError


regards aman..

[agent007se]

with AND without a semicolon :

QSqlError QSE = query.lastError();
QString tmp = QSE.text();
QMessageBox::warning(NULL, "", tmp);

QSqlError QSE = query.lastError();
QString tmp = QSE.text();
QMessageBox::warning(NULL, "", tmp);

To copy to clipboard, switch view to plain text mode 

tmp value:

"near "test": syntax error Unable to execute statement"

text() function

[jacek]

"near "test": syntax error Unable to execute statement"

It looks like your query is wrong. Can you execute that statement from SQLite console?

I don't use SQLite, but usually "CREATE TABLE xxx" is not enough --- you must add column definitions.

http://www.sqlite.org/lang_createtable.html

[gfunk]

After you call this:

1. QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
2. db.setDatabaseName(databaseFile->filePath());

do you call this?

1. bool ok = db.open();

If it succeeds, ok should be true.
If it doesn't, then all the following exec() calls will probably fail too.