Need Help with IF Statement

RC2020 · February 16, 2023, 5:57pm

Hello Everyone,

I need help with a IF Statement I need to change the Yes or No field to read TRUE or FALSE instead. (see my code below)

The check syntax says it is good but fails when tested. (See Below)

Thanks in Advance.

Miguel

jasond · February 16, 2023, 6:19pm

Try this
(case when x then y else z end)

NateS · February 16, 2023, 6:23pm

Or if you want to use if, you have to use the SQL version. The “Yes” or “No” is actually stored as a 1 or 0 in the field.

iif(JobOper.JobComplete=1,"True", "False")

RC2020 · February 16, 2023, 7:54pm

Hello Nate,

I am on E9 (Progress Database) and I tried your example with the same error. If you have any suggestions I would appreciate it.

Thank you.

Miguel

ckoch · February 16, 2023, 10:51pm

The IIF() function Nate suggests is only available in MS SQL Server 2012 and newer, but it’s really just syntactical sugar for the standard case/when statement. Jason’s on the right track.

You want case when JobOper.JobComplete = 1 then 'TRUE' else 'FALSE' end

gpayne · February 17, 2023, 12:03am

@RC2020 It has been a long time since ABL for most of us as you can see from the replies.

I found this from an old KB that I always referred to in those days. I did not see many else clauses in my old code, but they did seem to have periods behind them. I don’t have a running 9 system anymore, but googling ABL progress 4GL IF then else will get you some ideas.

BAQ Code Library.p (15.6 KB)

afabian · February 17, 2023, 8:06pm

If String(JobOper.JobComplete) = ‘No’ Then ‘FALSE’ Else “”