[RBASE-L] - Re: TEXT TO INTEGER

[Albert Berry]

You must quote the target variable.

GETPROPERTY Comp_SumSdays VALUE 'vSDaysTXT'

Jim Belisle wrote:

I did the trace on the report. I used Jan’s suggestion and changed my code.

CLEAR VAR vSDaysTXT, vSDaysINT, vDOrdersTXT, vDOrdersINT

SET VAR vSDaysTXT TEXT = NULL

SET VAR vSDaysINT INTEGER = 0

SET VAR vDOrdersTXT TEXT = NULL

SET VAR vDOrdersINT INTEGER = 0

SET VAR vAvgShipd REAL = 0

GETPROPERTY Comp_CountC VALUE vDOrdersTXT

GETPROPERTY Comp_SumSdays VALUE vSDaysTXT (this one does not work)

SET VAR vSDaysINT = (NINT(.vSDaysTXT))

SET VAR vDOrdersINT = (NINT(.vSDaysTXT))

SET VAR vAvgShipD = (.vSDaysINT/.vDOrdersINT)

-- PROPERTY Comp_AvgD CAPTION .vAvgShipD

SET VAR vCaption = +

('PROPERTY Comp_Avgd CAPTION '+(CTXT(.vAvgShipD)))

&vCaption

RETURN

It seems my GETPROPERTY command GETPROPERTY Comp_SumSdays VALUE vSDaysTXT is not working.