How to set the bind parameter to LOV in OAF
Recently i have been facing issues while binding parameters in LOV VO.
There is a small glitch while setting bind parameters in LOV
Consider the below one if you need to a set a bind parameter :
Never mention bind parameter and value, just make the whereClause and place it.
Normal way of bind and assigning values wont work.
Following is the way you need to use for LOV VO
Recently i have been facing issues while binding parameters in LOV VO.
There is a small glitch while setting bind parameters in LOV
Consider the below one if you need to a set a bind parameter :
Never mention bind parameter and value, just make the whereClause and place it.
Normal way of bind and assigning values wont work.
Following is the way you need to use for LOV VO
public void initDeptLOVVO()
{
Number dno= new Number(10);
String whereClause = "deptNo in ("+dno+")" ;
System.out.println("executed LOV VO ");
clearCache();
setWhereClause( whereClause );
executeQuery();
System.out.println("Dept Lov QUery-->"+getQuery() ) ;
}
No comments:
Post a Comment