More database problems

[poporacer]

Things are getting closer, but for some reason my SQL statments are not working properly. I am using SQLite. Not all of the data is getting put into the table.

code to create table:

void createDb()
{
    QSqlQuery query;
 
    query.exec("CREATE TABLE rider (id INTEGER PRIMARY KEY AUTOINCREMENT, "
               "LName TEXT, FName TEXT, weight REAL, notes TEXT)"); //Table creates properly with all the fields
    query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Ryan', 'Villapoto',185)"); // Villapoto gets put into table as FName    
    query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Jeremy', 'McGrath',155)"); // Nothing gets added
}

void createDb()
{
    QSqlQuery query;

    query.exec("CREATE TABLE rider (id INTEGER PRIMARY KEY AUTOINCREMENT, "
               "LName TEXT, FName TEXT, weight REAL, notes TEXT)"); //Table creates properly with all the fields
    query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Ryan', 'Villapoto',185)"); // Villapoto gets put into table as FName    
    query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Jeremy', 'McGrath',155)"); // Nothing gets added
}

To copy to clipboard, switch view to plain text mode 

I am sure it is something simple....but I can't find it