double check you don't have a space at the end of your report objects comp id name. NOT your code but the actual place where you enter the name. I've run into to this same issue when I copy the name for my code (by double clicking on the syntax word) and forget to remove that trailing space that is included. ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Thursday, May 06, 2010 8:14 AM Subject: [RBASE-L] - Re: TEXT TO INTEGER
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
