Subject | Re: CASE and SQL |
---|---|
Author | Michael Vilhelmsen |
Post date | 2005-01-20T11:39:13Z |
Thank you
This helped some...
BUT
Is it not posible to use a parameter after the WHEN clause ?
Like this:
Update Table set
F1 = :PF1,
F2 = (Case When (F1=0) then
(:PF1 * F3)
else
(:PF1 * (F2 / F1))
end)
The above doesn't seem to work...
Michael
This helped some...
BUT
Is it not posible to use a parameter after the WHEN clause ?
Like this:
Update Table set
F1 = :PF1,
F2 = (Case When (F1=0) then
(:PF1 * F3)
else
(:PF1 * (F2 / F1))
end)
The above doesn't seem to work...
Michael