It seems to be the same if I use it into a select where clause. Le mercredi 24 septembre 2014 16:50:00 UTC+2, [email protected] a écrit : > > Hello, > > I am searching a way for doing this : > > UPDATE XXX where *(select count(*) from XXX where ... )=0* and ... > > I have try with correlated subquery but it doesn't work, my subquery > become a field that I use into the update's where clause. But on runtime, > this field is not replace by the suybquery. > > Do you know why ? > > Example : > > // select subquery > Field<Object> lockedData = query > .selectCount() > .from(SUPPORT) > .where(SUPPORT.ID.equal("XXXX") > .and(SUPPORT.BUSINESSLOCK.equal("Process2#1").and( > SUPPORT.BUSINESSLOCK.isNull()))).asField("lockedData"); > > > //update query > int result = query.update(SUPPORT).set(SUPPORT.STATUS, 100) > .where(lockedData.equal(0).and(SUPPORT.ID.equal("XXXXX"))).execute(); > > At runtime, this update is executed : > > update "APP"."SUPPORT" set "APP"."SUPPORT"."STATUS" = 100 where > ("lockedData" = 0 and "APP"."SUPPORT"."ID" = 'AET_SUPPORT') > > Thanks for your help. >
-- 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/d/optout.
