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.
SET QUOTES="
.
.
SET VARIABLE voerrorn TEXT =" " -- (single space)
SET VARIABLE voerrore TEXT =" "
SET VARIABLE voerrord TEXT =" "
.
.
IF (vousage > 23) AND (measure = "HR") THEN – (vousage = 1665 in my test
sample)
SET VARIABLE voerrore = "E"
ELSE
SET VARIABLE voerrore = " "
ENDIF
.
.
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.
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.
