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
