Jim, For a variable label, try CAPTION instead of VALUE. And do put quotation marks around the variable name.
Bill On Thu, May 6, 2010 at 8:13 AM, Jim Belisle <[email protected]> wrote: > 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 > >
