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
