QSqlQuery to insert data to db returns lastError() = QSqlError(-1, "", "")

[windsword]

I also tried other combinations:

QSqlQuery query;
    query.prepare(QLatin1String(    "INSERT INTO Clients (ExpUserName, Password, FirstName, LastName,Email, Phone, CreateDate, LastModified, HarpGroup, isActive) VALUES (?,?,?,?,?,?,?,?,?,?)"));
....
if( !query.exec() )
        qDebug() << "> Query exec() error." << query.lastError().type();
    else
        qDebug() << ">Query exec() success.";

QSqlQuery query;
    query.prepare(QLatin1String(    "INSERT INTO Clients (ExpUserName, Password, FirstName, LastName,Email, Phone, CreateDate, LastModified, HarpGroup, isActive) VALUES (?,?,?,?,?,?,?,?,?,?)"));
....
if( !query.exec() )
        qDebug() << "> Query exec() error." << query.lastError().type();
    else
        qDebug() << ">Query exec() success.";

To copy to clipboard, switch view to plain text mode 

The error type is 0.