Posted by [IP Address: 194.154.214.69] 'Tom Namla' on August 21, 2001 at 05:21:34 EST:
In Reply to: (SQR 6806) String2Em: String to Decimal Object Conversion Error posted by [IP Address: 194.154.214.69] 'Eric Dykstra' on August 20, 2001 at 15:50:34 EST:
Hi Eric,
your code don't run BUT as I'm on my best behaviour ( I'm turning over a new leaf ) I'll leave out the sarcasm.
Sooooooo.
Begin-Select
LS.SupL_Wage_Rt,
LS.State,
LS.Suppl_SEP_Method
FROM PS_STATE_TAX_TBL LS
WHERE LS.STATE = <.GRADUATED_TBL_CD
AND LS.EFFDT = (Select Max(LS1.EFFDT)
FROM PS_STATE_TAX_TBL LS1
WHERE LS.STATE = LS1.STATE
AND LS1.EFFDT <= Current_Date)
End-Select
= <.GRADUATED_TBL_CD ----this field is'nt on PS_STATE_TAX_TBL
and = <. does'nt mean much
BUT THAT AIN'T THE PROB.
so............
looks to me like there are too many decimal places for SupL_Wage_Rt, maybe try cutting it down to 3 or decimal places with a SQL func (not SQR).