I suggest you change all your = " " to "= NULL" and check for nulls like
this:
SET VARIABLE voerrorn TEXT = NULL
SET VARIABLE voerrore TEXT = NULL
SET VARIABLE voerrord TEXT = NULL
.
.
IF (vousage > 23) AND (measure = "HR") THEN -- (vousage = 1665 in my test
sample)
SET VARIABLE voerrore = "E"
-- The ELSE is unnecessary since voerrore is already NULL
-- ELSE
-- SET VARIABLE voerrore = " "
ENDIF
.
.
IF voerrore IS NOT NULL or voerrord IS NOT NULL or voerrorn IS NOT NULL
THEN
INSERT INTO totalusage VALUES +
(.vocrew,.vodatex, .vocr_page, .vodotno, .vobegeqp, +
.voend1, .voend2, .voend3, .voend4, .vodnidle, .vousage, +
.voerrorn, .voerrore, .voerrord,.voeqpdesc)
ENDIF
On 6/26/2014 10:40 AM, Hodges, Dennis wrote:
I am running R:BASE eXtreme 9.5 (32) version 9.5.4.30626.
Here’s some additional code and comments that should explain more clearly.
ENDWHILE
DROP CURSOR c#1
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]
Please note: e-mail may be subject to public disclosure.
From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef
Sent: Thursday, June 26, 2014 11:42 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Logic error on if statement
What do you mean by " "? Is there a physical space between those quotes, or do you mean "IS NULL"?
And if it is a physical space, yet your null is set to " ", then there's another conflict. If you mean
null, then I would use the "IS NULL" in your if.
Karen
-----Original Message-----
From: Hodges, Dennis <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thu, Jun 26, 2014 10:40 am
Subject: [RBASE-L] - Logic error on if statement
In the following code, I know that the value of voerrore is “E”, voerrorn is “ “ and
voerrord is “ “. I have tried several different ways of expressing this (NE instead
of <>, using parens both for the entire if clause and each condition
separately). Everything I have tried causes a false condition for the IF statement
and jumps to the ENDWHILE. Can anyone tell me what I am doing wrong or suggest
another way of expressing this?
IF voerrore <> " " or voerrord <> " " or voerrorn <> " " THEN
INSERT INTO totalusage VALUES +
(.vocrew,.vodatex, .vocr_page, .vodotno, .vobegeqp, +
.voend1, .voend2, .voend3, .voend4, .vodnidle, .vousage, +
.voerrorn, .voerrore, .voerrord,.voeqpdesc)
ENDIF
ENDWHILE
DROP CURSOR c#1
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]
Please note: e-mail may be subject to public disclosure.
