@CheckFormulaSyntax and Designer says valid, @Eval says invalid

I have some formula code which I believe to be valid. It works fine if I put it in an agent, and @CheckFormulaSyntax says its fine. But if I use @Eval to run it, it reports back with the error “Invalid formula structure”.

An example of the code is

“fred” : @If(a = “”; “harry”; “george”) :

“john”

This code is just a made up example to highlight the problem. It can happen when a colon list concatenation operator is the last character of a line (no space after it).

Obviously the code can be fixed, but @Eval and @CheckFormulaSyntax should always agree on valid formula structure.

Subject: trying it out…

Sub Click(Source As Button) Const ferrule = {“fred” : @If(a = “”; “harry”; “george”) :

“john”}

Dim fo

fo = Evaluate(ferrule)

Print Join(fo, ", ")

End Sub

This executes without a problem. So, I think your issue has to do with what you are using as a newline character.