Posted by [IP Address: 130.166.63.199] 'Tom Namla's boyfriend' on August 21, 2001 at 17:16:20 EST:
In Reply to: Re: (SQR 6806) String2Em: String to Decimal Object Conversion Error posted by [IP Address: 130.166.63.199] 'Tom Namla' on August 21, 2001 at 05:21:34 EST:
hey Tommy, i thought you said you weren't going to post anything anymore? dang...
: 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).