Posted by Jim Guerber on August 29, 2011 at 10:21:15:
In Reply to: when CASE value is negative, SELECT/CASE fails.... posted by Bob A on August 29, 2011 at 08:53:46:
You forgot the case where sgn(xx) = 0.
That was tsken care of in the else statement that replaced it.
SELECT CASE SGN(WKPAYAMT)
CASE 0
WKPAY.CR = 0
WKPAY.DR = 0
CASE 1
WKPAY.DR = WKPAYAMT
CASE -1
WKPAY.CR = 0 - WKPAYAMT
ENDSELECT
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.