--- a/smf/smfcredentialmgr/smfcredmgrserver/src/smfcredmgrdbuser.cpp	Thu Sep 23 17:15:03 2010 +0530
+++ b/smf/smfcredentialmgr/smfcredmgrserver/src/smfcredmgrdbuser.cpp	Thu Sep 23 17:20:22 2010 +0530
@@ -377,9 +377,12 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthTokens);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aAuthAppId);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
 		//sometimes sqlStmt.Next returns KSqlAtRow even if no row is present
@@ -424,8 +427,10 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadURL);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aAuthAppId);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
@@ -459,8 +464,10 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadValidity);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aAuthAppId);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());	
 
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
@@ -492,8 +499,11 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadRegistrationToken);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aAuthAppId);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
@@ -527,8 +537,11 @@
 	TBuf<KMaxBufSize> tokenBuf(aRegToken);
 	err = sqlReadStatement.Prepare(iDataBase,
 			KSmfDbReadAuthAppIdInRegTokenTable);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, tokenBuf);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
@@ -564,9 +577,11 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthAppIdInPluginTable);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aPluginID);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
@@ -593,10 +608,12 @@
 	TInt paramIndex(KErrNone);
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aPluginID);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
 		//sometimes sqlStmt.Next returns KSqlAtRow even if no row is present
@@ -632,16 +649,20 @@
 	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	err = sqlStatement.Prepare(db, KUpdatePluginID);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	paramIndex = sqlStatement.ParameterIndex(_L(":iText"));
 	err = sqlStatement.BindText(paramIndex, newPluginBuf);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 
 	paramIndex = sqlStatement.ParameterIndex(_L(":iFlag"));
 	err = sqlStatement.BindInt(paramIndex, aFlag);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	paramIndex = sqlStatement.ParameterIndex(_L(":iID"));
 	err = sqlStatement.BindText(paramIndex, OldPluginBuf);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	err = db.Exec(KBegin);
 	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
 	err = sqlStatement.Exec();
@@ -686,9 +707,11 @@
 	TInt flag;
 
 	err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID);
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());	
 	paramIndex = sqlReadStatement.ParameterIndex(_L(":iID"));
 	err = sqlReadStatement.BindText(paramIndex, aAuthAppId);
-
+	__ASSERT_DEBUG( (err >= KErrNone), User::Invariant());
+	
 	while ((err = sqlReadStatement.Next()) == KSqlAtRow)
 		{
 		//sometimes sqlStmt.Next returns KSqlAtRow even if no row is present