hai
below method triggering but getting error,
i not declare any CHAR in any where...
but i assigning the date attribute but it showing error as iam using CHAR.
i think in dictionary table filed is the date datatype.
it is cause may be not matching the sql date and webdynpro date .
my assume is it write, tell me what i need to do .
that is not matching the error is:
"SELECT * FROM "TASK_DETAILS" WHERE "TASK_RECEIPT_DATE" = '2008-09-24' ORDER BY 1,2" contains the semantics error[s]: - 1:34 - type check error: the left hand side >>"TASK_RECEIPT_DATE"<< (DATE) and the right hand side >>'2008-09-24'<< (CHAR) of a comparison operator are not comparable
the method code is as below
if (taskRecDate != null
&& (taskStatus == null
&& taskHanByBD == null
&& taskNo == null
&& taskType == null
&& clientName == null)) {
Date TaskRecDate = Date.valueOf(taskRecDate.toString());
query = query + " TASK_RECEIPT_DATE = '" + TaskRecDate + "'";
} else if (taskRecDate != null) {
Date TaskRecDate = Date.valueOf(taskRecDate.toString());
query = query + "AND TASK_RECEIPT_DATE = '" + TaskRecDate + "'";
}
query = query + " ORDER BY TASK_NUMBER, TASK_TYPE";