More database problems

[ChrisW67]

It is infinitely more likely that the database is not what you think it is. If "rider.dat" already exists then it will be opened, otherwise it is created. If it already existed and the table rider already exists then your CREATE TABLE will fail leaving whatever structure was previously there. Depending on the structure this could cause your subsequent INSERTs to also fail, leaving whatever data was in the table still in the table. Delete rider.dat before you try again.

query.lastError() will return a QSqlError object that has some useful members. There's no point looking at it if the exec() indicated it succeeded though.

void createDb()
{
    QSqlQuery query;
    bool ok;
 
    ok = 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
    if (!ok) qWarn() << query.lastError().text();
    ok = query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Ryan', 'Villapoto',185)"); // Villapoto gets put into table as FName    
    if (!ok) qWarn() << query.lastError().text();
    ok = query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Jeremy', 'McGrath',155)"); // Nothing gets added
    if (!ok) qWarn() << query.lastError().text();
}

void createDb()
{
    QSqlQuery query;
    bool ok;

    ok = 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
    if (!ok) qWarn() << query.lastError().text();
    ok = query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Ryan', 'Villapoto',185)"); // Villapoto gets put into table as FName    
    if (!ok) qWarn() << query.lastError().text();
    ok = query.exec("INSERT INTO rider (FName, LName, weight)"
               "VALUES ('Jeremy', 'McGrath',155)"); // Nothing gets added
    if (!ok) qWarn() << query.lastError().text();
}

To copy to clipboard, switch view to plain text mode 

[poporacer]

I have been out of town for the last week. I tried your code and got a "qWarn was not declared in this scope. I included <QSqlError>. Where do I need to declare qWarn. I did get my SQL to work finally! I thank you for your help!

[ChrisW67]

#include <QDebug>

#include <QDebug>

To copy to clipboard, switch view to plain text mode