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
