--- a/phonebookengines/contactsmodel/cntplsql/inc/cntpplviewmanager.h	Wed Apr 14 15:45:35 2010 +0300
+++ b/phonebookengines/contactsmodel/cntplsql/inc/cntpplviewmanager.h	Tue Apr 27 16:23:35 2010 +0300
@@ -77,7 +77,8 @@
 	CCntSqlStatement* 		iSelectFullFieldsStmt;
 	};
 
-class NONSHARED CCntPplViewSession : public CTimer
+class NONSHARED CCntPplViewSession: public CTimer,
+    public MLplSqlDatabaseObserver
 	{
 public:	
 	static CCntPplViewSession* NewL(CPplContactsFile& aContactsFile, const CLplContactProperties& aContactProperties, CCntSqlStatement& aSelectAllFields, TInt aViewId, const CContactTextDef& aTextDef, TContactViewPreferences aViewPrefs);
@@ -94,6 +95,9 @@
 	
 	static void  TextFieldL(RSqlStatement& aSqlStatement, const CCntSqlStatement& aCntSqlStmt, const CContactTemplate& aSystemTemplate, TFieldType aFieldType, TDes& aText);
 	
+	// From MLplSqlDatabaseObserver
+    void OnCloseL(); 
+	
 private:
 	void ConstructL(const CContactTextDef& aTextDef);
 	CCntPplViewSession(CPplContactsFile& aContactsFile, const CLplContactProperties& aContactProperties, CCntSqlStatement& aSelectAllFields, TInt aViewId, TContactViewPreferences aViewPrefs);
@@ -121,11 +125,13 @@
 	
 	TContactViewPreferences iViewPrefs;
 	
-	CContactTextDef*		iTextDef;			
-	CCntSqlStatement*		iCntSqlStatement;
-	RSqlStatement*			iRSqlStatement;
-	RSqlStatement*			iCachedSqlStatement;
-	TBool 					iIsFastAccessFieldsOnly;
+	CContactTextDef*        iTextDef;
+    CCntSqlStatement*       iCntSqlStatement;
+    RSqlStatement           iRSqlStatement;
+    TBool                   iRSqlStatementReady;
+    RSqlStatement           iCachedSqlStatement;
+    TBool                   iCachedSqlStatementReady;
+    TBool                   iIsFastAccessFieldsOnly;
 	};