SQL Insert using ODBC ?

[allensr]

I have a MS Access 2003 database that I can hook into and query for results (ie SELECT column FROM table ...) and navigate the results. However, I am not able to insert anything programatically. I can if I go into the table via the MS Access GUI. The thing that is causing me concern is if I use the QSqlDriver::sqlStatement and return back all of the different statements, it only gives me statements for Select, where, and delete, but not for insert or update:

QSqlQuery query;
   QSqlDriver const * driver = query.driver();
   QSqlRecord rec = driver->record("testTbl");
   QString insertStatement = driver->sqlStatement(QSqlDriver::InsertStatement,"testTbl",rec,true);
   QString selectStatement = driver->sqlStatement(QSqlDriver::SelectStatement,"testTbl",rec,true);
   QString updateStatement = driver->sqlStatement(QSqlDriver::UpdateStatement,"testTbl",rec,true);
   QString deleteStatement = driver->sqlStatement(QSqlDriver::DeleteStatement,"testTbl",rec,true);
   QString whereStatement  = driver->sqlStatement(QSqlDriver::WhereStatement,"testTbl",rec,true);
 
   qDebug() << " Insertstatement " << insertStatement << endl;
   qDebug() << " Selectstatement " << selectStatement << endl;
   qDebug() << " Updatestatement " << updateStatement << endl;
   qDebug() << " Deletestatement " << deleteStatement << endl;
   qDebug() << " Wheretstatement " << whereStatement << endl;

QSqlQuery query;
   QSqlDriver const * driver = query.driver();
   QSqlRecord rec = driver->record("testTbl");
   QString insertStatement = driver->sqlStatement(QSqlDriver::InsertStatement,"testTbl",rec,true);
   QString selectStatement = driver->sqlStatement(QSqlDriver::SelectStatement,"testTbl",rec,true);
   QString updateStatement = driver->sqlStatement(QSqlDriver::UpdateStatement,"testTbl",rec,true);
   QString deleteStatement = driver->sqlStatement(QSqlDriver::DeleteStatement,"testTbl",rec,true);
   QString whereStatement  = driver->sqlStatement(QSqlDriver::WhereStatement,"testTbl",rec,true);

   qDebug() << " Insertstatement " << insertStatement << endl;
   qDebug() << " Selectstatement " << selectStatement << endl;
   qDebug() << " Updatestatement " << updateStatement << endl;
   qDebug() << " Deletestatement " << deleteStatement << endl;
   qDebug() << " Wheretstatement " << whereStatement << endl;

To copy to clipboard, switch view to plain text mode 

This code returns this:

Insertstatement ""
Selectstatement "SELECT RecNum, UniqueID FROM testTbl"
Updatestatement ""
Deletestatement "DELETE FROM testTbl"
Wheretstatement "WHERE RecNum = ? AND UniqueID = ?"

If I try to do it writing my own SQL insert statement, it "executes" but nothing goes into the table. I added the call to query.exeutedquery() and it returns an empty string.

if(!query.exec("INSERT INTO testTbl VALUES (10,20)"))
   {
      qDebug() << query.lastError().text();
      return false;
   }
 
   QString executedQuery(query.executedQuery());
   qDebug() << "executed query  " << executedQuery << endl;

if(!query.exec("INSERT INTO testTbl VALUES (10,20)"))
   {
      qDebug() << query.lastError().text();
      return false;
   }

   QString executedQuery(query.executedQuery());
   qDebug() << "executed query  " << executedQuery << endl;

To copy to clipboard, switch view to plain text mode 

executed query ""

Can anyone tell what Im missing? It's probably obvious... except to me

TIA