hasNext() returns false ,but the value of getEstimatedRowCount() is 1
404001Apr 5 2006 — edited Apr 6 2006ENV:
JDeveloper 10.1.3.0.4.3673
MySql 5.0
BaseTabImageStyleViewImpl voMaster = this.getBaseTabImageStyleView1();
ViewCriteria vc = voMaster.getViewCriteria();
if(vc==null){
vc = voMaster.createViewCriteria();
}else{
vc.clear();
}
ViewCriteriaRow vcr = vc.createViewCriteriaRow();
vcr.setAttribute("Id",id);
vc.addElement(vcr);
vc.setCriteriaMode(vc.CRITERIA_MODE_QUERY);
voMaster.applyViewCriteria(vc);
voMaster.executeQuery();
long len = voMaster.getEstimatedRowCount();
System.out.println(len);
voMaster.reset();
String parentId = null;
if(voMaster.hasNext()){
...
}
thanks