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:
Qt Code:
  1. void createDb()
  2. {
  3. QSqlQuery query;
  4.  
  5. query.exec("CREATE TABLE rider (id INTEGER PRIMARY KEY AUTOINCREMENT, "
  6. "LName TEXT, FName TEXT, weight REAL, notes TEXT)"); //Table creates properly with all the fields
  7. query.exec("INSERT INTO rider (FName, LName, weight)"
  8. "VALUES ('Ryan', 'Villapoto',185)"); // Villapoto gets put into table as FName
  9. query.exec("INSERT INTO rider (FName, LName, weight)"
  10. "VALUES ('Jeremy', 'McGrath',155)"); // Nothing gets added
  11. }
To copy to clipboard, switch view to plain text mode 
I am sure it is something simple....but I can't find it