Dennis
Have you tried
IF (voerrore IS NOT NULL AND voerrore <> " ") OR (voerrord IS NOT NULL
AND voerrord = " ") OR ( voerrorn IS NOT NULL AND voerrorn = " ") THEN
INSERT ..
ENDIF
If the above does not work then I would suggest traceing your file and
check the values of each and make sure NULL is set to -0- before trace
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Hodges,
Dennis
Sent: Thursday, June 26, 2014 11:39 AM
To: RBASE-L Mailing List
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
<mailto:[email protected]> [email protected]
Please note: e-mail may be subject to public disclosure.
