DH, RBASE by design often strips trailing spaces from data. You are setting yourself up a lot of difficulty by using spaces as data.
What is your reasoning for using spaces? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Hodges, Dennis Sent: Thursday, June 26, 2014 12:13 PM To: RBASE-L Mailing List 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]<mailto:[email protected]> Please note: e-mail may be subject to public disclosure. From: [email protected]<mailto:[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]> [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]<mailto:[email protected]> Please note: e-mail may be subject to public disclosure.
