[Solved] Problem with including QtSql

[A Former User]

yes it is the error QSqlDatabase No such file or directory

[stukdev]

Maybe is a linker problem, are you sure you have correctly installed qt?
And use correctly library? In this case i think you want build for 4.7 desktop right?

[A Former User]

yes right but my other example is working fine
here it is
@
#include <QApplication>
#include <QtSql>

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("testTwo");
db.setUserName("root");
db.setPassword("xxxxxx");

bool ok = db.open();
//qDebug() << db.lastError().text();
//qDebug() << ok;

QSqlQuery query(db);
query.exec&#40;"SELECT * FROM testTable"&#41;;
while(query.next()) {
    QString firstName = query.value(0).toString();
    QString secondName = query.value(1).toString();
    //int id = query.value(2).toInt();
    qDebug() << "First Name: " << firstName << "Last Name:" << secondName << "\n";
    //qDebug() << db.lastError();
}
return 0;

}

@

[Guest]

your pro files are similar? try clean build?

[A Former User]

you mean i should close my qt creator and open again write the code from start?
[quote author="chetankjain" date="1286900346"]your pro files are similar? try clean build?[/quote]

[Guest]

I meant, you have one project with working Qt sql code, and another failing to find the includes, so just compare the .pro files and see if they are similar.

Next, in Qt Creator, go to Build menu and select "Clean Project" option and then rebuild ... sometimes this could help ...

[A Former User]

i also did that clean project from build menu but still the same problem

i think both pro files are different
this .pro is for that example which is working
@
#-------------------------------------------------

Project created by QtCreator 2010-10-10T13:05:29

#-------------------------------------------------

QT += core gui

QT += sql

TARGET = dbExample
TEMPLATE = app

SOURCES += main.cpp
db.cpp

HEADERS += db.h
connection.h

FORMS += db.ui

@

and this is the one which is not working
@
#-------------------------------------------------

Project created by QtCreator 2010-10-12T01:37:23

#-------------------------------------------------

QT += core gui
QT += sql;

TARGET = untitled
TEMPLATE = app

SOURCES += main.cpp
mainwindow.cpp

HEADERS += mainwindow.h

FORMS += mainwindow.ui

@

[Guest]

The second one has a semi colon after SQL, try removing that.
You could use this directly
@
QT += core gui sql
@
better to have one definition instead of multiple, just easier to maintain

[A Former User]

yup your are right its working now

[Guest]

good to hear that

[stukdev]

Yes, but maybe you have to read some qt doc :P

[pcscrack]

This post is deleted!