Case statement added to functions¶

What is new - 6.0¶

A CASE statement has been added to the functions (see: Data Access Forums)

Entering the following case statement

select case {Customer.State}
    case 'AK'
        return 'cold'
    break
    case 'CA', 'AZ', 'NM', 'TX', 'LA', 'MS', 'GA', 'FL'
        return 'warm'
    break
    case 'HI'
        return 'aloha'
    break
    case else
        return 'dunno'
    break
end

in the function editor

Case Statement Function

Use of the above function resulted in:

Case Statement Results