Why not just use the variable that is being used with the Variable label. Seem to me you already have what you need. Victor Timmons Tiz's Door Sales, Inc Visit us at www.tizdoors.com <http://www.tizdoors.com/> P Please consider the environment before printing this e-mail
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, May 06, 2010 5:14 AM To: RBASE-L Mailing List 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
