diff -r 31968c23152c -r 931d0db6374d engine/src/ShowEngine.cpp --- a/engine/src/ShowEngine.cpp Fri Nov 19 01:47:31 2010 +0000 +++ b/engine/src/ShowEngine.cpp Sun Nov 21 20:11:07 2010 +0000 @@ -575,6 +575,23 @@ { User::Leave(KErrCorrupt); } + + // now update DB + _LIT(KSqlStatement2, "update shows set downloadstate=%d and deletedate = 0 where downloadstate=%d and deletedate != 0 and deletedate < \"%Ld\""); + iSqlBuffer.Format(KSqlStatement2, ENotDownloaded, EDownloaded, now.Int64()); + + + rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1, + &st, (const void**) NULL); + + if (rc == SQLITE_OK) + { + rc = sqlite3_step(st); + Cleanup_sqlite3_finalize_PushL(st); + CleanupStack::PopAndDestroy();//st + } + + DP("CShowEngine::DBGetOldShowsL END"); }