Posted by [IP Address: 204.107.47.108] 'Eric Dykstra' on August 21, 2001 at 15:00:54 EST:
In Reply to: Re: (SQR 6806) String2Em: String to Decimal Object Conversion Error posted by [IP Address: 204.107.47.108] 'Tom Namla' on August 21, 2001 at 05:21:34 EST:
You caught my error.... but I did try a function and it worked!
Begin-Select
Float(LS.SupL_Wage_Rt), &LS.Supl_Wage_Rt
LS.State,
LS.Suppl_SEP_Method
FROM PS_STATE_TAX_TBL LS
WHERE LS.STATE = 'Z2'
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
By the way, there are a lot of people out at www.sqrug.com with the same question posted. Do you know how to post a messge to that site?
Thanks,
Eric
: 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).