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 > > >
