Jan,
I was traveling for a couple of hours and as I was traveling I thought of the same thing. She works like a charm. Thanks. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, May 06, 2010 8:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TEXT TO INTEGER Jim, My apologies. We had been talking about DBCalc's so I thought the second control was one. If the variable lable shows the proper value, I don't think you need to use a GETPROPERTY. Just use the variable. GETPROPERTY Comp_CountC VALUE vDOrdersTXT SET VAR vDOrdersINT = (NINT(.vDOrdersTXT)) SET VAR vAvgShipD = (.vDSDays /.vDOrdersINT) SET VAR vCaption = + ('PROPERTY Comp_Avgd CAPTION '+(CTXT(.vAvgShipD))) &vCaption Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 6 May 2010 07:13:31 -0500 Subject: [RBASE-L] - Re: TEXT TO INTEGER Here are the controls in my footer band DistID# and there compIDs. Control name compID Variable label vDSDays Comp_Sumsdays the variable works but the GETPROPERTY code shows only a null value DBCalc Count(Control#) Comp_CountC The DBcalc works and the GETPROPERTY works Label label14 Conp_avgD Does not work because Comp_Sumsdays not working Comp_avgD is calculated by getting the values (with the GETPROPERTY commands) of vDSDays & dbcal. The problem is with the GETPROPERTY command on the variable label control. The controls themselves (except the label control) are properly reset for each DISTID# throughout the report. Jim ________________________________ From: [email protected] [mailto: [email protected]] On Behalf Of jan johansen Sent: Wednesday, May 05, 2010 5:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TEXT TO INTEGER Jim, I'm confused now. You wrote; 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. Is the second GETPROPERTY going to a 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
