Adding a dynamic where clause using named bind variables
The following piece of code is used to set a dynamic where clause to a view object. It also shows how to set values to the named bind parameters present in the dynamic where clause.
public void addWhereClauseWithNamedBindParams(){
ViewObject vo=this.getEmp1();
vo.setWhereClause(null);
vo.setWhereClause("Empno=:eNo");
vo.defineNamedWhereClauseParam("eNo",new Integer("7369"),null);
vo.executeQuery();
vo.removeNamedWhereClauseParam("eNo");
vo.setWhereClause(null);
}