If you can generate a standalone test case, I can look at fixing this.

On 2014-05-07 20:30, Carlos Alberto Eschiezaro Barreto wrote:
I'm using h2 in oracle mode and when I set double in prepareStatment the update 
process record only integer value.
Someone would help me here is the sql


update tb_parametro p set
p.nr_parametro = nvl(p.nr_parametro,0) + case when p.fl_data = 0 and (select 
c.fl_double from tb_contador c where
c.cd_sigla_contador=? )= 1 then? else 1 end
where  p.cd_parametro =  8;

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to