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.
