thank you Lukas,
But where I stuck up now.
*Actual SQL code is some thing like this :*
String updateQuery = "update emp_job_tree " +
" set computed_value = case when ( isnull(asp_type,0) ) = 1.0 then
isnull(sal.value,0) else isnull(sal.value,0) end " +
" from emp_job_tree uoijt ";
*Then equalent code in JOOQ , i have written is :*
ctx.updateQuery(uoijt).set(uoijt.COMPUTED_VALUE,
( ((DSL) ctx).decode().when( ((ASP_TYPE).nullif(new
BigDecimal(0))).equal(new BigDecimal(1.0)), (sal.VALUE).nullif(new
BigDecimal(0)) )
.otherwise((sal.VALUE).nullif(new BigDecimal(0)))
)).from(uoijt) ;
*In above snippet me getting one compilation error.*
Error-- "* The method
set(TableField<UserOverrideIndepJobTreeRecord,BigDecimal>,
Field<BigDecimal>) is undefined for the type
UpdateQuery<UserOverrideIndepJobTreeRecord> "*
Whole problem is
in the line "((ASP_TYPE).nullif(new BigDecimal(0))).equal(new
BigDecimal(1.0)"
BigDecimal
Cant i directly check with 0 simething like
*(ASP_TYPE).nullif(0))*
If yes, how can I do that ?
If not , how can resolve the Error-- "* The method
set(TableField<UserOverrideIndepJobTreeRecord,BigDecimal>,
Field<BigDecimal>) is undefined for the type
UpdateQuery<UserOverrideIndepJobTreeRecord> "*
Thank you.
~Shyam
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
