What is your NULL setting? If you have SET NULL " ", then it thinks your " " is a null, not a space.
I don't suggest ever using SET VAR xxxx = " " for anything because it can be interpreted differently depending on your null setting at the time. Karen -----Original Message----- From: Hodges, Dennis <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Jun 26, 2014 12:14 pm Subject: [RBASE-L] - RE: Logic error on if statement That didn’t work either. If I had some hair to spare, I’d be pulling it out about now. 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 Buddy Walker Sent: Thursday, June 26, 2014 12:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Logic error on if statement 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 [email protected] Please note: e-mail may be subject to public disclosure.
