Problem inserting data into sqlite

[thefatladysingsopera]

I have the following code in my save function.

void smith::on_saveButton_clicked()
{
 
    QSqlQuery query;
 
    query.prepare(
                "INSERT INTO application (firstname, lastname, country, city)) "
                "VALUES (:firstname, :lastname, :country, :city)"
                );
 
    query.bindValue(":firstname", "Alexis");
    query.bindValue(":lastname", "Nicholov");
    query.bindValue(":country", "Russia");
    query.bindValue(":city","Moscow");
    query.exec();
}

void smith::on_saveButton_clicked()
{

    QSqlQuery query;

    query.prepare(
                "INSERT INTO application (firstname, lastname, country, city)) "
                "VALUES (:firstname, :lastname, :country, :city)"
                );

    query.bindValue(":firstname", "Alexis");
    query.bindValue(":lastname", "Nicholov");
    query.bindValue(":country", "Russia");
    query.bindValue(":city","Moscow");
    query.exec();
}

To copy to clipboard, switch view to plain text mode 

The database connection is alright but it wont insert.Why?.

[Lykurg]

What error do you get? See QSqlQuery::lastError().


EDIT: You have a ) to much after city