Below is the code I'm using to perform a process of updating a table. I'm getting an error when I am trying to update the "ReviewDate". In my ViewObject I have the ReviewDate field formatted as MM/dd/yyyy. This is the error I'm getting: oracle.jbo.domain.DataCreationException: JBO-25009: Cannot create an object of typeracle.jbo.domain.Date with value:03/22/2005
Here is my code. Can anyone Help? Thanks, William
workDate = txtReviewDate.getText().substring(6,10) + "/" + txtReviewDate.getText().substring(0,5);
workReviewDate = txtReviewDate.getText();
ViewObject ProjectStatusVO = panelBinding.getApplication().getApplicationModule().findViewObject("ProjectStatusChangeView1");
ProjectStatusVO.setWhereClauseParam(0,workDate);
Row readRow;
readRow = ProjectStatusVO.first();
readRow.setAttribute("NewAtReview","true");
readRow.setAttribute("NewExisting","Existing");
readRow.setAttribute("ReviewDate",workReviewDate);
while (ProjectStatusVO.hasNext())
{
readRow = ProjectStatusVO.next();
readRow.setAttribute("NewAtReview","true");
readRow.setAttribute("NewExisting","Existing");
readRow.setAttribute("ReviewDate",workReviewDate);
}
ProjectStatusVO.closeRowSet();
panelBinding.getApplication().getApplicationModule().getTransaction().commit();
Here is my code. Can anyone Help? Thanks, William
workDate = txtReviewDate.getText().substring(6,10) + "/" + txtReviewDate.getText().substring(0,5);
workReviewDate = txtReviewDate.getText();
ViewObject ProjectStatusVO = panelBinding.getApplication().getApplicationModule().findViewObject("ProjectStatusChangeView1");
ProjectStatusVO.setWhereClauseParam(0,workDate);
Row readRow;
readRow = ProjectStatusVO.first();
readRow.setAttribute("NewAtReview","true");
readRow.setAttribute("NewExisting","Existing");
readRow.setAttribute("ReviewDate",workReviewDate);
while (ProjectStatusVO.hasNext())
{
readRow = ProjectStatusVO.next();
readRow.setAttribute("NewAtReview","true");
readRow.setAttribute("NewExisting","Existing");
readRow.setAttribute("ReviewDate",workReviewDate);
}
ProjectStatusVO.closeRowSet();
panelBinding.getApplication().getApplicationModule().getTransaction().commit();