Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
BC4J View WhereClause
- Thread starter ajith
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Use bind variables in the ViewObject Query tab. Make sure that you check 'Use ? style parameters' and in the WHERE clause include ---> TableName.Attribute = ?
in the code of the ViewImpl file (or whever you are instantiating the ViewObject) use:
public boolean doSomething(String value1, String value2) {
....
this.setWhereClauseParam(0,value1);
this.setWhereClauseParam(1,value2);
this.executeQuery();
....
}
namely bind parameter 1, bind parameter 2
J McCann
in the code of the ViewImpl file (or whever you are instantiating the ViewObject) use:
public boolean doSomething(String value1, String value2) {
....
this.setWhereClauseParam(0,value1);
this.setWhereClauseParam(1,value2);
this.executeQuery();
....
}
namely bind parameter 1, bind parameter 2
J McCann
- Thread starter
- #3
- Thread starter
- #4
- Status
