put a "pause using" after the GetProperty in your report and run it with a
Where Limit = 1 to see if the variable is populated by the GetProperty.
----- Original Message -----
From: "Jim Belisle" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, May 06, 2010 9: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
