Januz
29th June 2009, 00:31
Hi everyone!
I'm trying to connect to a qsqlite database, so far I get an open connection (at least open() returns true), but when i check lastError() I get this:
QSqlError(-1, "", "")
Queries return empty too. I've been googling my eyes out and can't find a solution (I don't even know what the problem is :p )
I'm using OS X 10.5.7 , QT 4.5.2 and QTCreator 1.2.
Here's the code:
#include <QDebug>
#include <QtSql>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
// db.setHostName("localhost");
// db.setDatabaseName("data.db");
db.setDatabaseName(":memory:");
if (!db.open()) {
qWarning("Can't open database");
} else {
QSqlQuery query;
query.exec("create table person (id int primary key, "
"firstname varchar(20), lastname varchar(20))");
query.exec("insert into person values(101, 'Danny', 'Young')");
query.exec("insert into person values(102, 'Christine', 'Holand')");
query.exec("insert into person values(103, 'Lars', 'Gordon')");
query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
QSqlQuery select;
select.exec("select * from person");
qDebug() << select.record().value(1).toString();
qDebug() << db.lastError();
qDebug() << QSqlDatabase::drivers();[/INDENT]
}
Principal w;
w.show();
return a.exec();
}
Thanks!
I'm trying to connect to a qsqlite database, so far I get an open connection (at least open() returns true), but when i check lastError() I get this:
QSqlError(-1, "", "")
Queries return empty too. I've been googling my eyes out and can't find a solution (I don't even know what the problem is :p )
I'm using OS X 10.5.7 , QT 4.5.2 and QTCreator 1.2.
Here's the code:
#include <QDebug>
#include <QtSql>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
// db.setHostName("localhost");
// db.setDatabaseName("data.db");
db.setDatabaseName(":memory:");
if (!db.open()) {
qWarning("Can't open database");
} else {
QSqlQuery query;
query.exec("create table person (id int primary key, "
"firstname varchar(20), lastname varchar(20))");
query.exec("insert into person values(101, 'Danny', 'Young')");
query.exec("insert into person values(102, 'Christine', 'Holand')");
query.exec("insert into person values(103, 'Lars', 'Gordon')");
query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
QSqlQuery select;
select.exec("select * from person");
qDebug() << select.record().value(1).toString();
qDebug() << db.lastError();
qDebug() << QSqlDatabase::drivers();[/INDENT]
}
Principal w;
w.show();
return a.exec();
}
Thanks!