Can NOT get the affected record number of UPDATE or DELETE

[byronk]

I'm using SQLite database engine to store data. When I use following code to update data, I can't get the number of records affected. The result of execute() is always 0. How to get the number of UPDATE or DELETE statement affected? Anyone has suggestions?

Code: Select all

   Statement update(*_session);
   update << "UPDATE MailAccount SET Type=?, Host=?, Port=?, User=?, Pass=?, Status=? WHERE ID=?",
      use(account.accType),
      use(account.host),
      use(account.port),
      use(account.user),
      use(account.pass),
      use(account.status),
      use(account.id);

   try
   {
      int rowAffected = update.execute();
      debugLog("Update record count: "+N2S(rowAffected));
   }
   catch (Exception& exc)
   {
      debugLog(exc.displayText());
      return false;
   }

[guenter]

Statement::execute() returns the number of rows extracted from the database.

You could try the following:

Code: Select all

*_session << "PRAGMA count_changes = ON", now;
int changes;
Statement update(*_session);
   update << "UPDATE MailAccount SET Type=?, Host=?, Port=?, User=?, Pass=?, Status=? WHERE ID=?",
      use(account.accType),
      use(account.host),
      use(account.port),
      use(account.user),
      use(account.pass),
      use(account.status),
      use(account.id),
      into(changes);

This is, however, SQLite specific. Another option would be to extend the Session class so that it provides a way to call sqlite3_changes(). This could be through a property, for example.

[byronk]

It works! Thanks.

[HardRock]

It does not work for me =(

MySQL connector. POCO 1.4.4


*stm << "UPDATE _table SET title = ?, WHERE id = ?",
Poco::Data::use( Info.Title ),
Poco::Data::use( Info.Id ),
Poco::Data::into( RowsAffected )
;

RowsAffected always == 0

How to get it work?