Yea it really shouldn't be that hard right? ..... Ok project number 4. >>> [EMAIL PROTECTED] 05/09/05 1:45 PM >>> Eric,
you could of course provide us with a patch that enabled native support for the NVL function .. ;-). Just an idea though. Werner Eric Anderson wrote: > Worked nicely... not as clean as it could be, because if I change the > mapping I have to remember to change the code. But it works. Thanks > > > > > > > >>>>[EMAIL PROTECTED] 05/06/05 2:01 AM >>> > > Hi Eric, > > OQL do not offer a NVL function. The only way that I can see is using > the SQL passthrough feature with the: > CALL <sql-select-statment> AS <classname> > syntax. > > Ralf > > Eric Anderson schrieb: > > >>I looked through the documentation... but couldn't see anywere where > > it > >>mentions this. >> >>How do I do a query like this >> >>WHERE (nvl(no_of_doses, 0)+nvl(extra_doses, 0)+nvl(adjusted_doses, 0) >>-nvl(under_doses, 0)-nvl(shared_doses, 0)-nvl(wasted_doses, 0) >>-nvl(given_doses, 0))>0 >> >> >> > > >
