Bill'
Thanks for the suggestion but it's a no go. I guess I will have to just start the variables on the report from scratch and see if that makes a difference. So far no suggestion has changed that one variable label. It does not seem to recognize the GETPROPERTY of that CompID. Jim I will be off line for a few hours and try it again. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, May 06, 2010 8:02 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TEXT TO INTEGER 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
