Hello, You're right, this is an API flaw. Short of using plain SQL (what you're already doing), there is currently no way to inline the "decimals" parameter of the round function. I have registered #2967 to fix this issue. https://github.com/jOOQ/jOOQ/issues/2967
Thanks for reporting, Lukas 2014/1/20 HK <[email protected]> > I resolved the problem by using DSL.function instead of DSL.round. > > The problem with DSL.round is the decimals parameter is processed as a > named parameter when I generate the SQL query. > With DSL.function I added decimals argument as Pram and I set the Param as > inline parameter. > > Is there another way to do ? > > Thanks > > Le lundi 20 janvier 2014 11:40:06 UTC+1, HK a écrit : > >> Hello, >> >> I am using jooq as SQL Query Builder. >> I need to add the round function in a named parameter query. >> In the round function, the decimals parameter is processed as a named >> parameter. >> Is there a way to inline the decimals parameter in the query ? >> >> Thanks in advance >> >> >> Round(Field<T> argument, int decimals) >> > -- > 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. > -- 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.
