Jim, If the first GETPROPERTY is working I would make sure that you have not mis-spelled your DB-Calc with the componentID of Comp_SumSdays.
Also look for maybe a trailing space in the componentid of your DB-Calc. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 5 May 2010 13:38:36 -0500 Subject: [RBASE-L] - Re: TEXT TO INTEGER 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. It comes up NULL each time. This compID is on the var vDSDays INTEGER. This var is created as a sum of another var vShipdays. Both of these var work. The vDSDays is a var label type. Any suggestions. Jim From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, May 05, 2010 1:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TEXT TO INTEGER Jim, I think you need to post your eep code again so we can look at it. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 5 May 2010 12:28:57 -0500 Subject: [RBASE-L] - Re: TEXT TO INTEGER I am trying to trace the report. What is the best way to trace a report? I have been creating a command file then trace it that way but RBASE locks up when I do it that way. I cannot find out why my text value is not changing to an integer. I have tried both INT and NINT functions and I only get NULLS or 0. Jim From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Wednesday, May 05, 2010 12:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TEXT TO INTEGER (NINT(arg)) Rounds a number that has a TEXT, REAL, DOUBLE, NUMERIC, or CURRENCY data type to the nearest integer, returning a value that has an INTEGER data type. In the following example, the value of vnint1 is 3 and the value of vnint2 is 4. SET VAR vnint1 = (NINT(2.6)) SET VAR vnint2 = (NINT(4.4)) Doug Jim Belisle wrote: What function do I use to change the text value of a GETPROPERTY command into Integer? Jim
