You are not logged in.
I am having trouble selecting on a Oracle decimal type and Oracle date type in tMap or tFilter. My Oralce table has a decimal type column, a date type column, and various others.
I am trying to select on the decimal type and get the error:
Incompatible operand types BigDecimal and int
I have put in 5069457 as the value. If I put in 5069457.0 as the value I get the same thing but it says double.
I am also trying to select on the date type and get the error:
The method compareTo(Date) in the type Date is not applicable for the arguments (int)
I have put in 18-06-2012 as the value.
Thanks for your response. I have attached screen shots. I put one of the criteria in tMap and the other in tFilterRow.
I subsequently put my criteria in the select statement of tOracleInput which worked, but I am still interested in knowing why these won't work in tMap or rFilterRow.