terminalsecurity/SCP/SCPDatabase/src/SCPParamDB.cpp
changeset 22 19fb38abab1d
parent 5 3f7d9dbe57c8
child 60 eb6690d0d439
--- a/terminalsecurity/SCP/SCPDatabase/src/SCPParamDB.cpp	Tue Feb 02 00:44:00 2010 +0200
+++ b/terminalsecurity/SCP/SCPDatabase/src/SCPParamDB.cpp	Fri Apr 16 15:52:47 2010 +0300
@@ -177,9 +177,7 @@
 
     __LEAVE_IF_ERROR(lDBView.Prepare(iParameterDB, TDbQuery(*lSelectQry)));
     __LEAVE_IF_ERROR(lDBView.EvaluateAll());
-    if(EFalse == lDBView.FirstL()) {
-        return KErrNotFound;
-    }
+    lDBView.FirstL();
 
     TInt lRowCount = lDBView.CountL();
 
@@ -214,9 +212,8 @@
     __LEAVE_IF_ERROR(lDBView.Prepare(iParameterDB, TDbQuery(*lSelectQry)));
     __LEAVE_IF_ERROR(lDBView.EvaluateAll());
     
-    if(EFalse == lDBView.FirstL()) {
-        return KErrNotFound;
-    }
+    lDBView.FirstL();
+
 
     TInt size(0);
     TInt lRowCount = lDBView.CountL();
@@ -333,7 +330,6 @@
         return KErrNone;  
     }
     
-    TInt lAffRows(0);
     HBufC* lDelQuery(NULL);
     
     if(iParameterDB.InTransaction()) {
@@ -353,7 +349,7 @@
             lDelQuery->Des().Format(KDeleteWhereParamIDValueDesAppID, aParamID, &(aParamValues[i])->Des(), aApp);
         }
 
-        lAffRows = iParameterDB.Execute(*lDelQuery);
+        TInt lAffRows = iParameterDB.Execute(*lDelQuery);
         _SCPDB_LOG(_L("[CSCPParamDB]-> INFO: Total rows affected=%d"), lAffRows);
         CleanupStack :: PopAndDestroy();
     }
@@ -419,7 +415,6 @@
 TInt CSCPParamDB :: DropValuesL(TInt aParamID, const TInt32 aApp) {
     _SCPDB_LOG(_L("[CSCPParamDB]-> DropValuesL() >>>"));
     
-    TInt lAffRows(0);
     HBufC* lDelQuery(NULL);
     
     if(iParameterDB.InTransaction()) {
@@ -439,7 +434,7 @@
     }
     _SCPDB_LOG(_L("[CSCPParamDB]-> SQL Query: %S"), &lDelQuery->Des());
 
-    lAffRows = iParameterDB.Execute(*lDelQuery);
+    TInt lAffRows = iParameterDB.Execute(*lDelQuery);
     _SCPDB_LOG(_L("[CSCPParamDB]-> INFO: Total rows affected=%d"), lAffRows);
     CleanupStack :: PopAndDestroy();