I have a problem. I have a view object which for which i set the where clause. vo.setWhereClause("LOY_CARD_NO = "+ nID ); vo.executeQuery(); The query returned me a proper query which when I ran in toad gave the row i wanted. The view object sql query is SELECT clc.CCD_CUST_CD, clc.LOY_CARD_NO, FROM CCD_LOY_CUST clc WHERE clc.LOY_CARD_NO = :CARD_NO
Now when I tried to fetch data in my JSF it was empty. I even tested the appModule . It worked there. But my vo.getEstimatedRowCount() returns 0 Why?
Joined: Aug 23, 2008
Ok I understood why this happened.
I tried .setNamedWhereClauseParam("ID",nID )
But another question why does my view object sometimes display details and sometimes not..... Is it the way i am initializing it?
1.ApplicationModule am = ADFUtils.getApplicationModule("CustAppModule");