Posted by [IP Address: 193.130.16.8] 'Shan ' on August 22, 2001 at 07:43:53 EST:
In Reply to: Re: (SQR 6806) String2Em: String to Decimal Object Conversion Error posted by [IP Address: 193.130.16.8] 'Tom Namla's boyfriend' on August 21, 2001 at 17:16:20 EST:
lmmfaooooooo@ Tom Nallas bf. Bloody hilarious.
And Tom... what you on about mate ? True Tom style ? Yep, you got that right - if style means not knowing the answer but posting some bollocks ANYWAY.
;) Shan
: 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).