Looking for a really basic database example

[N3wb]

I've done a little PHP programming before, so I'm at least a little familiar with SQL syntax, but I'm struggling to understand how to use a database with QT. All of the examples I've been able to find have been really complicated and I was hoping that someone could post (or link to) just a really basic example of how to interact with a local database?

For instance, I've tried the following:

QSqlDatabase db;
 
    db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("test.db");
    if (db.open())
    {
        QSqlQuery query;
        qDebug()<<"\n**** db  opened**** :";
        qDebug()<<query.exec("create table person (id int primary key, "
                "firstname varchar(20), lastname varchar(20))");
    }

QSqlDatabase db;

    db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("test.db");
    if (db.open())
    {
        QSqlQuery query;
        qDebug()<<"\n**** db  opened**** :";
        qDebug()<<query.exec("create table person (id int primary key, "
                "firstname varchar(20), lastname varchar(20))");
    }

To copy to clipboard, switch view to plain text mode 

But the application output is:

**** db opened**** :
false

I can't seem to get anything to work..

Thanks for your help

[tbscope]

Make sure that the create table syntax is correct with respect to SQLite.