Insert CODE using Qt c++gui to SQLite

See more:

C++

SQLite

QT-Creator

Hi,

I just need help with my project. I am using Qt creator for Mobile symbian OS.
I just would like to know what is the best Insert Command to enable the user to save input data into SQLite.

I have this code:

void addtrnsc::on_pushButton_clicked()
{
    QSqlDatabase myDB = QSqlDatabase::addDatabase("QSQLITE");
    myDB.setDatabaseName(Path_to_DB);

    if (!myDB.open())
    {
        QMessageBox::critical(0, tr("no Con"), tr("unable to stablish"));
        return;

    }
    QSqlQuery query;
    query.exec("insert into expense values(Descrition, Amount, Type, Date) VALUES ("+ui->txtDescrip->text()+","+ui->txtamount->text()+","+ui->comboxtype->currentText()+","+ui->dateEdit->text());
}

or can you give me a sample logic that will insert input data to databse..

I do not know if what is next and I do not know if it will work.
Can someone please help me with this?

Thanks